Forum Discussion
How to use conditional formatting to highlight differences between two columns
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).
- Hi
I tried using that formula alone but fidnt work but ill look at row numbers again.
AA is red font colours
AC is total occupants.
I want AC to change cell to red if AA and AC do not match
Thanks