Forum Discussion
Solved
Conditional Formatting Issue on Table Office 365
Hello, I am trying to use this formula for conditional formatting on a particular column in a table but whenever I try to paste the formula into the conditional formatting rule it gives me the e...
Conditional formatting doesn't work with structured references directly The workaround is to use INDIRECT() like
=AND(INDIRECT("Table1[@[Batch Lot]]")="",INDIRECT("Table1[@[Delivery Date]]")-TODAY()<14)
SergeiBaklan Thank you, that worked perfectly!
Derek-Ude , you are welcome