A
AnisaF
In Conditional fromatting, is there any way for using the OR operator to
check multiple conditions.
check multiple conditions.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Sure
=OR(A1>17, B1<8)
--
HTH
RP
(remove nothere from the email address if mailing direct)
=OR(A1>17, B1<8)
--
HTH
RP
(remove nothere from the email address if mailing direct)
A
Akhilesh Dalia
Hi,
You can use multiple conditions instead of OR by clicking on ADD>> button
Regards
Akhilesh Dalia
akhileshdalia<at>hotmail<dot>com
You can use multiple conditions instead of OR by clicking on ADD>> button
Regards
Akhilesh Dalia
akhileshdalia<at>hotmail<dot>com
A
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.
I tried using =IF(OR(A4="B",A3="F",A3="A"),True,False) in the conditional
format formula box, and it finally got evaluated.
B
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)
=OR(A4="B",A3="F",A3="A")
as that returns True or False
--
HTH
RP
(remove nothere from the email address if mailing direct)
A
AnisaF
Hi Bob,
I tried doing your method, but there was an error message.
I tried doing your method, but there was an error message.
A
AnisaF
Thank you Bob, You are right......I tried it again.