How to do "OR" in conditional formatting
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!!
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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!!
-
Excellent!
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives