There are many ways to create a colour drop-down list in Microsoft Excel. You can insert an ActiveX control and then assign a colour to the background of the control. You can configure conditional formatting so that a different colour shows in the cell based on the cell's value. However, the simplest way to create a drop-down box with a coloured background is to create a separate lookup list somewhere in the spreadsheet, consisting of choices for the drop-down box. Change the background colour of the cells for the lookup list and then use the lookup list as the drop-down box for the selected cell.
- Skill level:
Other People Are Reading
Go to a section of unused cells in the spreadsheet.
Type the choices that will appear in the drop-down list. Type one choice per cell and compose a list of choices with each selection under the previous one.
Highlight all cells in the list and then right-click on the highlighted block of cells.
Click "Format Cells" from the context menu.
Click the "Fill" tab and then click on the desired colour for the background of the lookup list (the selected cells).
Click "OK." The background colour of the cells is set.
Create Lookup List With Background Color
Select the cell where the drop-down options will be placed.
Click "Data" from the top navigation bar. Click "Validation."
Click the "List" option from the "Allow" drop-down list.
Click the "Source" icon from the top navigation bar and drag the cursor over the lookup list. Alternatively, type the range of cells defining the lookup list, such as "(=$A$1:$A$4)."
Tick the box next to the "In-Cell Dropdown" option and then click "OK." The lookup list now appears as a drop-down box in the selected cell.
Add the Lookup Cells As a Drop-down Box
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for