If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|