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
cells.

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:
=A1="Pass"
Format: Green fill

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

Condition 3, Formula is:
=A1="Fail"
Format: Red fill

Click to OK out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"creative schwabbie" wrote:
Hi,

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?

Thanks!