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)
Derek-Ude Haven't tried with table references, but in your second example you are trying to match cells from row 2 and down to values in an entire column. This will cause the conditional format to be offset by one row, as shown in your picture. Change "Y2" to "Y1" or set the range to e.g. "G2:G10000". Then it should work.