| 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. |
| 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 | |||
Threaded Mode
