How to do "OR" in conditional formatting

Eva M

Hello, I have a column which receives answers from a form. The form is basically a test for nurses. I have conditional formatting set up in the answer column that if the answer arriving is NOT the correct answer, then the cell with the wrong answer turns red.

Now the managers decided to change the wording in one of the answers. I changed the form, but I have not changed the conditional formatting because we already have thousands of answers with the old word. I worry that if I change the conditional formatting to have the new word, all the old correct answers will turn red because they contain the old word. Is that correct? Is there a way around it? I don't see an option for "or" in the conditional formatting.

Example: Old answer was: "The sky is blue". The new answer is: "The sky is azure."

I already have many answers marked as correct (not red) - but those answers are based on the answer and conditional formatting with the word "blue".

I now changed the test answer to be "azure" but left the conditional formatting with "blue". Doesn't this mean that all new answers will be marked as wrong? But if I change the conditional formatting to "azure", then all the old answers will be marked as wrong. Correct?

Any way around this?

Thank you!!

Andrée Starå

Hi Eva,

You can clone the Conditional Formatting Rule and update the copied one with the new wording.

Would that work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Eva M

Thank you, Andree! You put me on the right path - I first changed the word in the dropdown of answers themselves, saved it, THEN opened the conditional formatting, and clicked on the old rule, where now the new answer was written IN ADDITION to the old answers AND it allowed me to mark two answers as correct, ultimately basically creating an "or" rule. So it all works now. I got to this by doing the clone the rule thing and noticed both answers were displayed...so I went back to the original rule that also had them. THANK YOU!!

Andrée Starå

Excellent!

Happy to help!