Conditional Formatting

[Roady]

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

 

[Tom Hutchins]

Yes. Use 3 'Formula Is' conditions. For the Green condition, set Formula Is
to this:

=OR(A1="Approved - A", A1="Approved - B", A1="Approved - C")

For the Red condition, set Formula Is to this:

=OR(A1="Rejected - A", A1="Rejected - B")

For the Grey condition, set Formula Is to this:

=(A1="Dropped")

In this example, A1 is the first cell with the text to be evaluated. You can
put the conditional formatting on A1 itself, or on another cell based on what
is in A1. You can use Format Painter to copy the conditional formatting to
other cells.

Hope this helps,

Hutch