Automation or Conditional Formatting

Gaurav Chauhan
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

Answers

  • Jake Gustafson
    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
    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
    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).