View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amie Amie is offline
external usenet poster
 
Posts: 4
Default Macro to change color of tab based on color of cell

Hello -

I would like to write a macro that will change the color of the
worksheet tab based on the color of cells. For example I have
conditional formating that will highlight cells in yellow. I want a
macro that says:

If cells in worksheet change to yellow
then
Change the tab to yellow

Can anyone help me with this?