Conditional Format to Identify Error

[tmo4ever]

I have two different sheet that I'm using to compare data.

I have column A in Sheet1 that has a list of 4-digit numbers that I know to be accurate. In Sheet2, I have column b that represents user-entered data. I want to highlight anything in Sheet2 Column B that doesn't match the one of the value in Sheet 1 Column A.

Any help? If there is a better way to do this (rather than Conditional Format), I'd love to hear the suggestions.

I also have to say that I love this community!

 

[mole999]

Try this, select your sheet1 column A values, in the Namebox (where is normally shows a1, or whatever cell you have) type a name of your choice (this is your range)

on sheet2, i used column C

=VLOOKUP(B1,name,1,0) ' where name equals your lookup

drag this value down your columns, any that don't match will show as #N/A

matches will show the exact value