Thread: colour macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Afia Afia is offline
external usenet poster
 
Posts: 7
Default colour macro

I wonder if some can help\suggest, I'm creating a report and would like to
add shape to represent status. Is it possible to automate the shape to shorw
red, amber or green by clicking on it? Can I assign a dropdown to a shape or
do I need to write a macro and assign it to a shape? Please advise.
Afia