@exceltips247: Drop down menu in Excel with color - Excel Tips and Tricks Learn how to make a job done menu in Excel with color. Here the steps outline in my video. Create drop-down list 1) Select the Status column 2) Data ~ Data Validation 3) Settings tab 4) Allow = List 5) Source = Completed, Not Started, Pending 6) OK Add color to a drop-down list 1) Select the Status column 2) Home ~ Style ~ Conditional Formatting 3) Highlight Cell Rules ~ Text That Contains... 4) Assign colors 5) OK 6) Repeat steps for remaining of pull down selections How do you make a drop down menu in Excel with color?,How do I add color to a drop-down list in Sheets?,How to customize a drop-down list in Excel?,How do I add color to my drop down menu?,Create drop down list with color in Excel and Google Sheets, #fyp #excel #tiktok #fypシ