Automation or Conditional Formatting

Gaurav Chauhan

Hi Team

How do I place a conditional rule for a scenario on a column where I have a drop down setup for Multi Select with values '1', '2', '3' and 'A'.

The condition should highlight the cell if the user selects 'A' along with any other ('1', '2' or '3')

This is to remind user to remove the 'A' if they have picked '1', '2' or '3' and their combinations

No color reminder required for Just selecting 'A'

Please suggest

Jake Gustafson

For a Multi-Select column, you can use the Conditional Formatting option "If <column> contains 'A' then apply this format to the entire row (or specific columns).

Gaurav Chauhan

Hi, But the condition should work only if "A" has been selected in Tandem to 1/2/3 or their combinations.

Jake Gustafson

Ok, I used a helper column to make this happen.

Column 1 has a Multi-Select option of 1, 2, 3, A

Column 2 has a Column Formula equal to that of the previous column

Conditional Formatting is as follows:

• If <column 1> contains '1' or '2' or '3' and <column 2> contains 'A' then apply this format to the entire row (or specific rows).