Vlookup with text & conditional formatting

[blkane]

Is this possible in excel? I was a little concerned I was asking for the
impossible here.

I have a named range that contains text only. I would like to use this
range in a vlookup statement in a conditional formatting formula.

Think of a calendar format where each day has a different activity assigned
to it. I would like the vlookup to identify the category type of the
activity. If it is category 1, I would like the cell highlighted in blue, if
it is category 2, I would like to higlight the cell in green, etc.

The problem that I am seeing is that the text in the cell does not contain
the criteria for assigning the cell format. This information is contained in
column 2 of the array.

I'm pretty good with lookups, conditional formatting and find statements but
I don't know how to link them all into one activity.

Thanks

 

[blkane]

Okay, never mind. I figured it out. I needed to simplify the words in
column 2 of the array so it didn't have to use a FIND formula.

Thanks