3.8K
SHAdd Color coded drop down list in Excel with just two Excel features.
1) Add drop down lists using the data validation option
Select all cells
Go to Data tab and select Data validation under data tools
Select List and list out all the options you want in the drop down under source
Hit enter and you have your drop down list
2) Add colors using conditional formatting
Select all cells
Go to Home Tab > Conditional Formatting > Highlight Cell > Text that contains
Enter the text and select the Color you want
Repeat and add rules for all the options
Don’t forget to share it with your work bestie 👩💻
#excel #msexcel #corporate #worklife #msoffice
@sheetsensei
