View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Narnimar Narnimar is offline
external usenet poster
 
Posts: 132
Default How to format Green conditionally b1 if a1 is only Green?

I do color indication in cell a1 once I finished a perticular job as Green.
My Cell b1 has conditionally formatted already for yellow if job is started.
Now once a1 is Green I want b1 also has to be Green. How can I do that in
excel 2007? Thank you in advance for any help.