If a1 is not equal to b1 then highlight..How do you set that up?

[RobinTMathew]

I'm thinking its a conditional format but not totally sure. I could use some help here. Basically I have two columns. I'm trying to find the discrepancies (items non matching in column a). Those item that do not match side by side (i.e. a1 should match b1, a2 should match b2, a3 should match b3, etc.) should be denoted by a different color and/or highlight.

Thanks in advance!

 

[Oaktree]

Yep, conditional formatting. Select your range, go to format --> conditional formatting, change "Cell Value Is" to "Formula Is", and set the formula as "=$A1<>$B1" (without the quotes, modifying the row numbers according to the active cell).

 

[RobinTMathew]

Thanks alot!!!!

 

[RobinTMathew]

Out of curiousity why does some of the cells that do match end up highlighted? Even some that do not match are not highlighted. Majority are but why is there the few that are not behaving according to the formula?

 

[Oaktree]

Two reasons could be:

(1) Double check that your formatting is applied to the right rows (e.g. A2's conditional formatting should not be referencing A3)
(2) The displayed value might not equal the value stored in the cell. For example, if one cell has 1.57 & the other cell has 1.62 and both cells are formatted to one decimal place, they'll both show "1.6" as the value, but they're different.