Conditional Formatting

[Special-K]

There's lots written about conditional formatting. My mind is still spinning.

Can somebody tell me if the following is possible?

- - - - - - - - - - - - - -
CURRENT SETUP
- - - - - - - - - - - - - -
Condition 1
Formula Is ........ =(A92="LV") ........... (An entry of LV will turn the cell blue)

Condition 2
Formula Is ........ =(A92="ED") ........... (An entry of LV will turn the cell orange)

Condition 3
Formula Is ........ =(A92="PD") ........... (An entry of LV will turn the cell green)

- - - - - - - - - - - - - -
WHAT i'D LIKE TO ACHIEVE
- - - - - - - - - - - - - -
Condition 1
Formula Is ........ =(A92="LV" OR "LH") ........... (An entry of LV or LH will turn the cell blue)

Condition 2
Formula Is ........ =(A92="ED" OR "EH") ........... (An entry of ED or EH will turn the cell orange)

Condition 3
Formula Is ........ =(A92="PD" OR "PH") ........... (An entry of PD or PH will turn the cell green)

I don't know how to write it ... of if it's even permitted within the Conditional Formatting.
Currently each field reads:
Formula Is =(A92=LV")
Formula Is =(A92=ED")
Formula Is =(A92=PD")

Help ... please?

- Kevin.

 

[Brian from Maui]

Use the OR function,

=OR(A92="LV",A92="LH")

 

[HalfAce]

Hello Kevin,
Condition 1
Formula Is. . . =OR(A92="LV",A92="LH") and format to blue.

Condition 2
Formula Is. . . =OR(A92="ED",A92="EH") and format to orange.

Condition 3
Formula Is. . . =OR(A92="PD",A92="PH") and format to green.

 

[Special-K]

THANKS!

I'm humbled ... once again.

Thank you for all the help and guidance!