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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use an OR function with SEARCH in conditional formatting?
Hi,
Try this formula in conditional formatting OR(ISNUMBER(SEARCH("rejected",A10)),ISNUMBER(SEARC H("cancelled",A10))) -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "RAYCV" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use an OR function with SEARCH in conditional formatting?
If you want OR, try
=OR(ISNUMBER(SEARCH("rejected",$F4)),ISNUMBER(SEAR CH("cancelled",$F4))) You said "as well", so if you want AND, change OR to AND in the above formula. -- David Biddulph "RAYCV" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use an OR function with SEARCH in conditional formatting?
A few keystrokes shorter:
=COUNTIF($F4,"*rejected*")+COUNTIF($F4,"*cancelled *") =COUNT(SEARCH("rejected",$F4),SEARCH("cancelled",$ F4)) -- Biff Microsoft Excel MVP "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... If you want OR, try =OR(ISNUMBER(SEARCH("rejected",$F4)),ISNUMBER(SEAR CH("cancelled",$F4))) You said "as well", so if you want AND, change OR to AND in the above formula. -- David Biddulph "RAYCV" wrote in message ... 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 |
Reply |
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 |