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