| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If or and conditional formatting using wild card
I have applied 3 conditional formats to a cell and need to apply a 4th. I
thought I could amalgamate one of the conditions to cover this 4th option but I'm not sure what to do. I am in cell A3 and the condition currently is =if(or(D3=Housing Benefit NIHE",E3="Housing Benefit NIHE"),and(A3="Housing Benefit NIHE")) the cell changes to red if condition met. Cell A3 could have an entry Housing Benefit NIHE or Housing Benefit RCA so as I have no more options to put in a 4th condition to cover "Housing Benefit RCA" I would like the cell to change to red if cell contains the words "Housing Benefit". I think I may have to use ISNUMBER(SEARCH but I'm not sure how to join the whole formula together. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If or and conditional formatting using wild card
=IF(OR(D3=Housing Benefit NIHE",E3="Housing Benefit NIHE"),AND(OR(A3="Housing
Benefit NIHE",A3="Housing Benefit RCA"))) "jimar" wrote: I have applied 3 conditional formats to a cell and need to apply a 4th. I thought I could amalgamate one of the conditions to cover this 4th option but I'm not sure what to do. I am in cell A3 and the condition currently is =if(or(D3=Housing Benefit NIHE",E3="Housing Benefit NIHE"),and(A3="Housing Benefit NIHE")) the cell changes to red if condition met. Cell A3 could have an entry Housing Benefit NIHE or Housing Benefit RCA so as I have no more options to put in a 4th condition to cover "Housing Benefit RCA" I would like the cell to change to red if cell contains the words "Housing Benefit". I think I may have to use ISNUMBER(SEARCH but I'm not sure how to join the whole formula together. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If or and conditional formatting using wild card
..... wrong .... What exactly are you testing ...
If D3 OR E3="Housing Benefit NIHE" AND A3="Housing Benefit NIHE" OR ="Housing Benefit RCA" then turn RED .... =AND(OR(D3="Housing Benefit NIHE",E3="Housing Benefit NIHE"),(OR(A3="Housing Benefit NIHE",A3="Housing Benefit RCA")) ?? "Toppers" wrote: =IF(OR(D3=Housing Benefit NIHE",E3="Housing Benefit NIHE"),AND(OR(A3="Housing Benefit NIHE",A3="Housing Benefit RCA"))) "jimar" wrote: I have applied 3 conditional formats to a cell and need to apply a 4th. I thought I could amalgamate one of the conditions to cover this 4th option but I'm not sure what to do. I am in cell A3 and the condition currently is =if(or(D3=Housing Benefit NIHE",E3="Housing Benefit NIHE"),and(A3="Housing Benefit NIHE")) the cell changes to red if condition met. Cell A3 could have an entry Housing Benefit NIHE or Housing Benefit RCA so as I have no more options to put in a 4th condition to cover "Housing Benefit RCA" I would like the cell to change to red if cell contains the words "Housing Benefit". I think I may have to use ISNUMBER(SEARCH but I'm not sure how to join the whole formula together. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If or and conditional formatting using wild card
Thanks this worked perfectly
"Toppers" wrote: .... wrong .... What exactly are you testing ... If D3 OR E3="Housing Benefit NIHE" AND A3="Housing Benefit NIHE" OR ="Housing Benefit RCA" then turn RED .... =AND(OR(D3="Housing Benefit NIHE",E3="Housing Benefit NIHE"),(OR(A3="Housing Benefit NIHE",A3="Housing Benefit RCA")) ?? "Toppers" wrote: =IF(OR(D3=Housing Benefit NIHE",E3="Housing Benefit NIHE"),AND(OR(A3="Housing Benefit NIHE",A3="Housing Benefit RCA"))) "jimar" wrote: I have applied 3 conditional formats to a cell and need to apply a 4th. I thought I could amalgamate one of the conditions to cover this 4th option but I'm not sure what to do. I am in cell A3 and the condition currently is =if(or(D3=Housing Benefit NIHE",E3="Housing Benefit NIHE"),and(A3="Housing Benefit NIHE")) the cell changes to red if condition met. Cell A3 could have an entry Housing Benefit NIHE or Housing Benefit RCA so as I have no more options to put in a 4th condition to cover "Housing Benefit RCA" I would like the cell to change to red if cell contains the words "Housing Benefit". I think I may have to use ISNUMBER(SEARCH but I'm not sure how to join the whole formula together. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wild Card Search | Excel Worksheet Functions | |||
| wild card -- help with formula | Excel Discussion (Misc queries) | |||
| Wild card * | Excel Worksheet Functions | |||
| Is it possible to use a wild card in a =COUNT(IF equation? | Excel Worksheet Functions | |||
| Wild Card and Dates | Excel Worksheet Functions | |||
Linear Mode
