View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mkinney mkinney is offline
external usenet poster
 
Posts: 1
Default Linking data between sheets to change color of cell?

I am trying to create a simple sync between two sheets. We have township
range section names and I want to enter a simple Y or N on one sheet for the
work being completed there. Then I want that Y or N answer to change the
color of the associated cell in the next sheet. Is there an easy way to do
this? I tried searching this discussion board but there are so many various
topics and my 'tech' lingo is not quite what it used to be. :)

Thanks for your help ahead of time.

Mike