Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional format
i have used two of the functions but ii need to have a color to hightlight
all cells that have parking, p, prk |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional format
Do you want to higlight cells having these values or containing these in
their values? To highlight Cell A1 (in the latter case) Choose Conditional Formatting Use FORMULA IS =OR(A1="parking',A1="prk",A1="p") and format as you want In the former case you really need to have value CONTAINING p "skc" wrote: i have used two of the functions but ii need to have a color to hightlight all cells that have parking, p, prk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |