How Do I Create a Color Drop Down Box in Excel?

Written by tammy clevenger | 13/05/2017
How Do I Create a Color Drop Down Box in Excel?
You can use coloured drop-down boxes in Excel. (Jupiterimages/ Images)

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.

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.

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.

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.