Hi

I have a column of client states (F2:F48) that I would like to have automatically highlighted if a particular "F" cell's value matches one of the values in Q3:Q16.

I am using Excel 2010. I tried a conditional format based on "=MATCH(F12,Q3:Q16,0)" but it didn't work.

I also searched this formum for use of MATCH and FORMAT, but didn't find anything that would work, but then maybe I couldn't figure out how to apply it to my situation. Sort of a "conditional format" novice.

I would appreciate any help.

Thanks!
Jim