View Single Post
  #3   Report Post  
Old April 7th 07, 12:40 AM posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default Colorful Dropdown Lists

The coloring effect can be achieved via applying conditional format on the DV

Assume your DV list is applied to col A.

Select col A (A1 active),
click Format Cond Formatting, and apply it as:

Condition 1, Formula is:
Format: Green fill

Condition 2, Formula is:
=A1="Not Executed"
Format: Yellow fill

Condition 3, Formula is:
Format: Red fill

Click to OK out
"creative schwabbie" wrote:

I've seen it in other sheets but can't figure out how to create one. I'm
trying to create a dropdown list that changes color whit each selection. For
instance, Pass = Green, Fail = Red and Not Executed = Yellow. I'm able the
create the dropdown list and put it in the cell but can't seem to give it
color. Does anyone know how?