Drop Down

[pdrouin]

Does anyone know how to create a drop down that
accomodates cell color fill options? I would like to
create a single cell drop down option with color fill
choices of red, yellow, or green for example.

 

[Debra Dalgleish]

You could use a combination of Data Validation and Conditional
Formatting to colour the cells.

Select the cell in which you want the dropdown
Choose Data>Validation
From the Allow dropdown, select List
In the Source box, type: Red,Yellow,Green
Click OK

With the cell still selected, choose Format>Conditional Formatting
Leave the first dropdown as "Cell Value Is"
From the next dropdown, choose 'equal to'
In the text box, type: Red
Click the Format button
Choose Red as a font colour, and pattern colour
Click OK
Click Add

Repeat the above steps for Yellow and Green
Click OK

Select a colour from the dropdown list, and the cell will be filled with
that colour.

 

[Gord Dibben]

pdrouin

Assuming C5 to be the DV list cell.

In your Data Validation>List box type Green,Red,Yellow(note the commas must be
entered)

Select a C5 and Format>Conditional Formatting and Condition1 Cell Value is:
="green" Format to Green color.

"Add" and do same for Condtion2 and ="red"

Same for Condition3 and ="yellow"

OK your way out.

With C5 still selected Format>Cells>Number>Custom enter ;;; and OK

Now click on drop-down arrow and select from the Green,Red,Yellow list.

C5 will turn color.

Gord Dibben Excel MVP