Forum Discussion
How to use conditional formatting to highlight differences between two columns
Hello I have applied these three conditions formatting as the first on its own didn't work (had to add col AD with a true or false statement)... =$AA9<>$AC9 make it red =$AD9=FALSE make it red...
The rule for conditional formatting works as intended if the "applies to" range is:
=$AA$9:$AC$26
Fyi it's a refreshable table if that makes a difference