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
- Still highlights same data
Can you attach a screenshot which shows the data and the manager for conditional formatting? A screenshot like the one in my last reply.
so I want to show if the red font colours are different to total occupants column (highlight in total occ col)
Here's my cond formatting
