Forum Discussion
Conditional Formatting - Any Limits on Formulas
I am using conditional formatting in a very useful way to help with reconciliation between two datasets that are similar but in a very different format. I have one condition that is working perfectl...
You cannot use structured table references such as TBLTPVSheet[BillValue] in a conditional formatting formula. You'll have to refer to the A1-style address of the ranges instead.
- Thanks Hans. That's exactly what I needed to hear. I've adjusted my formula to avoid the use of the Table references, and the conditional formatting is now working as desired.
Sidenote: Its annoying that table references are not allowed in conditional formatting, AND further that the Excel conditional formatting editor is not more helpful in helping users to know that this is why the formula doesn't work.
