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

RobinTMathew

Board Regular
Joined
Mar 2, 2010
Messages
88
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!
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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).
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,214,584
Messages
6,120,385
Members
448,956
Latest member
JPav

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top