Home |
Search |
Today's Posts |
#1
|
|||
|
|||
conditional format
I would like a cell to turn red if I enter L or PB.
Normally I would use a 2 conditional formats 1 for L and 1 for PB, but I need more than 3 conditional formats. Is there a way to combine the one for L and PB? |
#2
|
|||
|
|||
When setting up the conditional format, set condition 1 to "Formula is"
and use a formula like this: =OR(A1="L",A1="PB",A1="X") You can set as many conditions as an OR() statement will accommodate: 30. |
#3
|
|||
|
|||
Thanks Dave that worked great.
"Dave O" wrote: When setting up the conditional format, set condition 1 to "Formula is" and use a formula like this: =OR(A1="L",A1="PB",A1="X") You can set as many conditions as an OR() statement will accommodate: 30. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format problem | Excel Discussion (Misc queries) | |||
Conditional Format Titles | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions | |||
Conditional Format With SUMIF | Excel Worksheet Functions |