Hey all this should be an easy one, but my brain isn't working today.
So I have two columns of data: columns A and B
I want to have conditional formatting highlight cells in column B that are not an exact match of the adjacent value in column A.
So A2 = 13109 and B2 = 13109. it's a match, so don't format it
but A3 = 2500000 and B3 = 0. Since there is a discrepancy I want this highlighted (and I want the highlight to show up in the B column). I guess it could also work to have both cells be formatted where there is a discrepancy if that's easier.
What worked for me originally was to highlight A2:B2 and apply conditional formatting for unique values, but then I would have to do it manually for A3:B3, and A4:B4, one pair of cells at a time.
I know there is a better way, but I just can't figure it out at the moment.
thanks in advance!
Bookmarks