Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Colour all the cells the colour of the rest and add one CF condition of
=OR(A2="S",A2="V",A2="P") -- __________________________________ HTH Bob "Heder" wrote in message ... I have a set of data, there are a few possible entries: S V A P E [NUMBER] T [NUMBER] A [NUMBER] I would like to have the S, V, and P cells all be one colour and the rest be another colour. How would I define the conditional formatting to make this work? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need help with a conditional format in regards to "date" input | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
"Daisy-Chain" a conditional format? | Excel Discussion (Misc queries) | |||
Conditional Format Formula "includes" | Excel Discussion (Misc queries) | |||
conditional formula to show "open" or "closed" | Excel Worksheet Functions |