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.
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.