Forum Discussion
Table conditional formatting
Hi all, I am trying to compare a column which is an index match returned value to a static value cell. And highlight any variances in the index match column if different. =[@[Updated Departm...
You can use the structured references if they are 'hidden' within a defined name.
= (updated = original)
"where"
updated = Table1[@updated]
original = Table1[@original]It gets rid of direct cell referencing with the mixed $ anchoring but whether that is worth the effort is a matter of opinion.