View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
creative schwabbie creative schwabbie is offline
external usenet poster
 
Posts: 1
Default Colorful Dropdown Lists

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!