If or and conditional formatting using wild card

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jimar - 18 Jun 2007 16:11 GMT

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 to this Message

Toppers - 18 Jun 2007 16:52 GMT

=IF(OR(D3=Housing Benefit NIHE",E3="Housing Benefit NIHE"),AND(OR(A3="Housing
Benefit NIHE",A3="Housing Benefit RCA")))

> 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
[quoted text clipped - 7 lines]
> "Housing Benefit". I think I may have to use ISNUMBER(SEARCH but I'm not sure
> how to join the whole formula together.

Reply to this Message

Toppers - 18 Jun 2007 17:08 GMT

.... 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"))

??

> =IF(OR(D3=Housing Benefit NIHE",E3="Housing Benefit NIHE"),AND(OR(A3="Housing
> Benefit NIHE",A3="Housing Benefit RCA")))
[quoted text clipped - 10 lines]
> > "Housing Benefit". I think I may have to use ISNUMBER(SEARCH but I'm not sure
> > how to join the whole formula together.

Reply to this Message

jimar - 20 Jun 2007 14:14 GMT

Thanks this worked perfectly

> .... wrong .... What exactly are you testing ...
>
[quoted text clipped - 20 lines]
> > > "Housing Benefit". I think I may have to use ISNUMBER(SEARCH but I'm not sure
> > > how to join the whole formula together.

Reply to this Message