Or operator

[AnisaF]

In Conditional fromatting, is there any way for using the OR operator to
check multiple conditions.

 

[Bob Phillips]

Sure

=OR(A1>17, B1<8)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Akhilesh Dalia]

Hi,

You can use multiple conditions instead of OR by clicking on ADD>> button

Regards

Akhilesh Dalia
akhileshdalia<at>hotmail<dot>com

 

[AnisaF]

Thanks to both of you,

I tried using =IF(OR(A4="B",A3="F",A3="A"),True,False) in the conditional
format formula box, and it finally got evaluated.

 

[Bob Phillips]

You don't need the IF, jus

=OR(A4="B",A3="F",A3="A")

as that returns True or False

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[AnisaF]

Hi Bob,

I tried doing your method, but there was an error message.

 

[AnisaF]

Thank you Bob, You are right......I tried it again.