Hi Bob,

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

"Bob Phillips" wrote:

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" wrote in message
...
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" wrote:

Sure

=OR(A117, B1<8)

--

HTH

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


"AnisaF" wrote in message
...
In Conditional fromatting, is there any way for using the OR operator
to
check multiple conditions.
--
Anisa