View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
andoscott andoscott is offline
external usenet poster
 
Posts: 1
Default Can you change the color of one cell based on the color of another

I have a list of items to be completed in one column. As the items are
completed I color the cell green. There is another column that I would like
to color green as the items in the first column are colored. Is there a way
to link the colors of the cells so that when I change the color of one cell
the color of another cell changes also?