Need Help with Excel Conditonal Formatting Problem

[calihiker]

I'm trying to format the cells in column A with a yellow background to show if they 'do not' (a false comparison value) match the value in column B, ...that I know how to do. The problem is, in addition to that, I need to ignore a 'False' comparison between the two columns if cells in column A have certain string values (name(s)). And I have been unable to figure it out correctly. I'm thinking I might need to use the OR operator to compare the value in Column A to a list of names that would flag a false positive, but haven't figured out how to get the whole thing to work.. So to restate, I do not want the cell in column A to be yellow if it doesn't match the value in column B ONLY IF the value in Column A is matches any of a short list of 'exception' name(s)/value(s).

Any help would surely be appreciated, thanks.
Andre

 

[xlbo]

How long is the list of "excepted names" ??? can you provide them ??? If there's not too many, it shouldn't be a problem

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
Get the best answers to your questions - faq222-2244

 

[calihiker]

Not long, "Supp#" (where # is between and 10) & "Pander"