conditional formatting with OR in Excel! Solved

Question

Hello,  I have tried several ways but I haven't found the right one!  The cell value is ; equal to ; OR(="option1";="option2";="option3") The cell value is ; equal to ; "option1";"option2";"option3" The cell value is ; equal to ; =OR("option1";"option2";"option3") The formula is ; =OR("option1";"option2";"option3") ...  To say that I have tried everything but nothing works?!??!? Please, can you tell me how to do conditional formatting with multiple choices for the same format (because I need the other 2 conditions (with multiple choices)).  Thank you   Configuration: Windows XP / Internet Explorer 8.0

Patrice33740 · Accepted Answer

Re,<> In H9 enter: =OR(H9="";H9="None";H9="Done and pending") =OR(H9="Reminder done";H9="Done and pending (Reminder done)") and copy the formatting down to H108 If you use multiple conditional formatting rules for a cell: - either you determine the order in which they should apply (which one is priority), - or in your equation, you take into account the other cases, for example: =AND(OR(H9="";H9="None";H9="Done and pending");H9<>"Received and approved") Best regards Nicolas always says: “It’s easy when you know the answer!”

Patrice33740 · Answer

Hello,  The formula is =OR("option1","option2","option3") should work!  Can you specify the exact formula you are using?

lucasp · Answer

Hello,  Well, I redid them "as they are supposed to work" here is a copy-paste:  The formula is; =OR("";"None";"Done and pending")  And another one  The formula is; =OR("Reminder done";"Done and pending (Reminder done)")  And another one but it works  The cell value is; equal to; ="Received and approved"  They all don’t work except for the last one!!  WHY ????  Thank you!

Patrice33740 · Answer

Re,  Assuming cell A1 contains "The formula is," the correct syntax is: =OR(A1="";A1="None";A1="Done and pending") =OR(A1="Reminder done";A1="Done and pending (Reminder done)")  -- Nicolas always says: "It's easy when you know the answer!"

lucasp · Answer

Re,  Thank you, now it works halfway...  =OR(H9:H108="";H9:H108="None";H9:H108="Done and pending")  =OR(H9:H108="Reminder done";H9:H108="Done and pending (Reminder done)")  Okay, I noticed that depending on the order of the formulas, it changes something... They are read from top to bottom!  So, if I put an OR in condition 1, all my cells turn (red) and it doesn't take into account the others and even my condition: The cell value is; equal to; ="Received and approved" It no longer works, it must be in condition 1 and then it depends on which OR I put in second ALL my cells turn (red) Even those supposed to be in condition 3...  ??????????

lucasp · Answer

Thank you, I found it at the same time :) !  But it's still stupid (anti-ergonomic) on Excel's part!!  When I select my range of cells where I want my conditional formatting. The first selected cell is always different... So I have to create the formulas based on it only and the rest adapts =OR(H108="Reminder done";H108="Done and pending (Reminder done)")  Thank you!

Conditional formatting with OR in Excel!

6 réponses

How to get the character µ on the android keyboard.

Texture issues in enshrouded

Access issue to my "contact me" profile

Windows spotlight is not working.

My tv turns off and then on again repeatedly?

Executable from a python file

Pay in 4 installments cdiscount

The alt gr key is not working on my keyboard.

Code 80072efe how to get windows update working again

Video in ".3gp" format