Drop down menus are quite common while working with Excel. One of our reader has this requirement of using color coding in excel drop down menu. Here is the exact requirement:
I have created a drop down menu in excel with three values – Critical, Major and Minor. I want to have different background colors along with the text when I select a particular value. For example when I choose Critical, background should be Red and text in cell should appear as Critical and so on.
We thought it would be a good idea to share the solution here for benefit of all our readers. Here is a step by step process to use color coding in excel drop down:
Step1: Create a drop down menu in excel by selecting a cell and selecting Data->Validation as shown in the image below:
This is how the drop down menu should look like:
Step3: Now, select the cell on which drop down is created and select Format->Conditional Formatting as shown in the image below:
This will launch a window as shown below:
Step4: Select the Conditions appropriately and it should look as below:
Step5: Now for each condition, click on “format” button present on right hand side under each condition. This will launch a window as shown below. Select “Pattern” tab and select appropriate color.
When you a select a menu, this is how the drop down cell will look like.
Hope you like the steps mentioned here. Feel free to let us know your suggestions and feedback.