Forum Discussion
How to use conditional formatting to highlight differences between two columns
The rule for conditional formatting works as intended if the "applies to" range is:
=$AA$9:$AC$26
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
Do you mean red font numbers or actually red font colours? Unfortunately i can't tell anything from your first screenshot because of that. In addition the screenshot doesn't show the column descriptions and row numbers.
Concerning the rules for conditional formatting you only need rule =$AA10<>$AC10 and the applies to range =$AA$10:$AC$1048576.
Make sure that the rule and the applies to range start in the same row. With the conditions shown in the screenshot the formatting is shifted by one row because the rule starts in row 10 and the applies to range starts in row 9 (all highlighted in yellow in the screenshot below).