Forum Discussion
Compare one column to another.
I am putting together a payroll sheet. I have one column of max allowable units per client and another column of used units. I need to compare these columns and have excel highlight the that dont use...
=$A2>$B2You can try this rule for conditional formatting which seems to work in the screenshot.
=$A$2:$B$12This is the "applies to" range of the conditional format.