View Single Post
  #2   Report Post  
Old April 7th 07, 12:28 AM posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Colorful Dropdown Lists

I'm assuming that you created the dropdown list via data|validation.

Look at Format|Conditional formatting.

This won't shade the options, but it will shade the cell after you've updated
the cell.

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?



Dave Peterson