Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Or operator
In Conditional fromatting, is there any way for using the OR operator to
check multiple conditions. -- Anisa |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Hi,
You can use multiple conditions instead of OR by clicking on ADD button Regards Akhilesh Dalia akhileshdalia<athotmail<dotcom "AnisaF" wrote: In Conditional fromatting, is there any way for using the OR operator to check multiple conditions. -- Anisa |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
Thank you Bob, You are right......I tried it again.
"AnisaF" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BIMDAS - Order of Calculation | Excel Discussion (Misc queries) | |||
"--" operator in a formula | Excel Worksheet Functions | |||
Analyzing non numerical data in an excel spread sheet | Excel Worksheet Functions | |||
hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION | Excel Worksheet Functions | |||
How to Concatenate Time with some operator? | Excel Worksheet Functions |