Conditional formatting to identify unique values by row

[leimst]

Hello,


I am comparing 2 columns row by row attempting to identify where values in any given row do not match. I wanted to use conditional formatting and the formula "=A2<>B2" through the end of the spreadsheet, e.g. "=A100<>B100" so that Excel would highlight in red those rows that did not match. Instead, Excel seems to be looking at all of A2:B100 as a whole and evaluating for uniques. I could accomplish the same thing by using a formula such as "=A2=B2" in column C and letting Excel return True or False but I would like to accomplish without using another column.


Thank you in advance for any help,


Leimst

 

[jason]

try something like

=IF(NOT(A2=B2))

 

[leimst]

Still having trouble getting this to run...I must be setting my range incorrectly or something.


Leimst

 

[Hui]

Leimst


Select A2:B100

Goto CF

Apply using a Formula

=$A1<>$B1

set format

Apply


This will highlight rows that Don't match


You may want to delete existing CF first just in case you have been adding them on top of existing CF's