Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use an OR function with SEARCH in conditional formatting?
I am creating a conditional format using the thfe following formula
=SEARCH("rejected",$F4) I also need the cell to be highlighted if F4 contains the word cancelled as well. Brain not in gear can't work it out. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting with text search | Excel Discussion (Misc queries) | |||
Conditional formatting on a function | Excel Discussion (Misc queries) | |||
Conditional formatting on a function | Excel Discussion (Misc queries) | |||
Help on a function with Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting "OR" function | Excel Worksheet Functions |