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).
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives