Conditional Formatting with multi select dropdown list

CLuke
CLuke ✭✭
edited 12/09/19 in Smartsheet Basics

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.

    Multi-Select Dropdown Column and Criteria.png

    Need more information? πŸ‘€ | Help and Learning Center

    こんにけは (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!πŸ‘‹ | Global Discussions