Excel Table Spreadsheet Macro

[Cassandra Smith]

I have copied an Excel spreadsheet into a macro for Confluence so that we have a live document. I cannot get the =<TODAY() formula to stick so the cells change color when the date is past today. 

[Stiltsoft support · Accepted solution]

Hi @Cassandra Smith ,

Seems that the Table Spreadsheet macro is ours (I assume we are talking about the Table Filter and Charts for Confluence app).

If this is the case, you may use the following workaround: make sure that your dates are formatted as dates and use the conditional formatting.

Go to the Conditional format tab:

And create a new rule for your cells:

=DATEDIF(A1,TODAY(),"D")>0

Hope it helps your case.

[Stiltsoft support]

Hi @Janice ,

Please add some custom tags for us:

• table-filter
• table-filter-and-charts
• table-spreadsheet

Thank you!

[Cassandra Smith]

YES!! This worked! Thank you so much for your guidance!! 

[Craig Nodwell · Accepted solution]

Hi @Cassandra Smith welcome to the community.  What macro are you using?  Is it the Office Excel Macro?  Please note that the macro only displays the data when published, it does not execute any formula's within the spreadsheet.

[Cassandra Smith]

I am using the Office Excel Macro, the page is published. Thank you for the information.