Conditional Formatting Based on Values in another Cell

[jdegeorge]

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

[jdegeorge]

Hi

I finally found another post's solution that I was able to tweak for my needs...

Thanks anyway!

[jdegeorge]

I take it back. This solution is not 100% accurate. Would really appreciate help!


Column AColumn B
New YorkBoston
CaliforniaChicago
BostonCalifornia


Based on this example, I would like to conditionally highlight "California" and "Boston" in column A because they matched values in column B.

How can I do that, please???

[DBY]

Hello
If your example data is in cells A2:B4, then the following conditional formatting formula applied to A2:A4 should work:

Please Login or Register  to view this content.

Hope this helps.
DBY

[jdegeorge]

I needed to put $ in front of my lookup range column and rows! Duh!

This worked. Thanks VERY much!

[DBY]

Yes, I thought that from your original post but when you said it was solved I didn't post a reply.

DBY