How to color code a Data Validation
AnsweredIs there a way to assign a cell fill (color) dependent on the data validation selected instead of manually doing a cell fill? For instance, I have a 3 options in my new data validation; "In progress, Not started, and Close" and I want "in progress" to show a cell fill of green; "Not started" to show a cell fill of Yellow..and so on.
0
-
Sure - just use conditional formatting. here's a link to the help guide:
Documents/Workbooks: https://success.workiva.com/help/workbooks/conditional-formatting
Spreadsheets: https://success.workiva.com/help/spreadsheets/conditional-formatting-in-spreadsheets0I did the conditional formatting, but it looks like you can only condition number or formula, is that correct? 0
Comments
3 comments