Conditional formatting with OR in Excel!

Hello,

The formula is =OR("option1","option2","option3") should work!

Can you specify the exact formula you are using?

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!

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!"

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...

??????????

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!