View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alistair22 Alistair22 is offline
external usenet poster
 
Posts: 1
Default How do I create a drop down cell menu with different colour cells

I want to create a drop down menu in a cell where the only answers are Red,
Amber or Green, but I want the cell to background fill with the colour!

Thanks in advance!!

Alistair