Use Conditional Format with Match Statement

**battlek** · 12-30-2009, 03:26 AM

Hey all. I am having an issue with a worksheet I'm working on that I hope somebody can help.

I have a list of 31 values in separate cells. The values are three digit letter codes. Here is an example of 5 of them:

ATL
GMI
WOB
COI
PTS

What I am wanting to do is have a Conditional Format to change the color of the cell to Pale Blue if the value equals another cell that is within a range.

Sorry if I didn't make sense, but I've been up for awhile working and I'm sure you understand.

Thank you very much!

**teylyn** · 12-30-2009, 03:33 AM

Hi battlek,

welcome to the forum.

I'm afraid this requires some clarification:

What I am wanting to do is have a Conditional Format to change the color of the cell to Pale Blue if the value equals another cell that is within a range.

Which other cell? Which range?

Maybe you could upload a workbook with some sample data that illustrates the issue? Mock up your expected results manually and explain the logic that leads to the result. You can upload a file by clicking "Go Advanced" below the Quick Reply box and then the paper clip icon.

cheers

**battlek** · 12-30-2009, 03:43 AM

Sorry about that. Again, a bit tired.

Well, I am attaching a very basic mockup of what I am going to need.

Essentially, if a value in the list on the right is within the list on the left, the cell will turn Pale Blue.

I hope this helps.

Let me know if you need any more info, and thanks again!

**ConneXionLost** · 12-30-2009, 03:48 AM

Hi battlek,

Welcome to the forum!

Use this formula in the Conditional Formatting of the G2 cell:

Code:

=MATCH(G2,$C$3:$C$10,0)

Then use the format paintbrush to copy it down to the other cells.

Cheers,

**battlek** · 12-30-2009, 09:52 AM

Wow, that was easy enough. Sorry, but apparently I was just not getting it exactly right. I did try that method, but I didn't have exactly what you had written. Shows you how good staying up to work on projects is for you!

Thank you very much again guys. I'm sure there will be more questions along the way!