Conditional Formatting with multi select dropdown list
When using Conditional Formatting, I want to make my primary column change colors when a combination of choices are made in a multi select dropdown,.
What it looks like now is this: If column 2 is 'condition' and column 3 contains 'condition one' or 'condition two' then apply this format to the column one
Is there a way to change it to column 3 contains 'condition one' AND 'condition two' ?
Thanks for any help you can give
Comments
-
Hi CLuke,
When you're in the conditional formatting window creating the conditions for rule, if you select the options in the list for the dropdown column it will automatically format this to be an "or" statement.
To create an "and" statement from a multi-select drop-down column type, click "define custom criteria" when selecting the criteria for the rule. Then, choose "contains," typing in your "condition 1", and create a new "contains" for "condition 2" so that the rule only applies if both criteria are met.
Please see the screenshot attached below.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives