View Single Post
  #1   Report Post  
Old April 7th 07, 12:24 AM posted to microsoft.public.excel.worksheet.functions
creative schwabbie creative schwabbie is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2007
Posts: 1
Default Colorful Dropdown Lists


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?