conditional formatting does not contain

I am trying to make a row highlight where the cell value does not contain L00 or X00 and highlight if anything else has been entered but cant seem to find how to do this. Any ideas
Comments
-
Hi Andy,
Would it work if you added the L00 and X00 as Not equal to and the Is not blank?
Hope that helps!
A possible workaround would be to add a so-called helper column with a formula checking a box if the above is true/false.
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.
-
Why would the conditional formatting tool include "contains" but not "does not contain?" Just ¯\_(ツ)_/¯ Why, why, why. Dumb.
-
Hi @andyc ,
Not sure if this helps but at the bottom of the Set Condition screen there is an option for when condition is not met.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives