Automation or Conditional Formatting
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
-
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).
-
Hi, But the condition should work only if "A" has been selected in Tandem to 1/2/3 or their combinations.
-
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).