Hi:
I know that Excel 2003 only allows a Max of 3 conditional formats. I am
wondering if there is a formula that can better address my needs.

I have 6 different groups of words that I want to trigger 3 different colors
depending on what is selected:

Approved- A (green)
Approved- B (green)
Approved- C (green)
Rejected- A (red)
Rejected- B (red)
Dropped (grey)

I am using the 'Cell Value is =' selection to do this. Is there a way to
solve this with a formula?

Is it possible to do this?
Thank you,
JR