All the drop-down lists are the same style, so can the styles of the lists be set to different colors? The answer is definitely yes. Please follow Bian Xiao to set different colors. The whole process is very simple.

Excel drop-down menu options background color setting steps:

1. First, you need to add a drop-down menu on the page.

2. Find the Start → Conditional Format in the toolbar.

3. Then, select Highlight Cell Rule → Other Rules.

4. Select the appropriate format in the position shown in the figure.

5, you can choose a variety of different colors.

6. After setting the color, click OK.

7. Set the conditions to be met to be equal, and then fill in the contents in the drop-down list.

8. Click on the application and you will find that the color has changed.