View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LrngasIgo LrngasIgo is offline
external usenet poster
 
Posts: 6
Default Cell shading in linked cells

I've got a workbook with several sheets that all have pretty much the same
list of spare parts on them that are all linked together somehow by formulas.
If I change the cell color on the master list I want the cell color to
change on all the lists. For example part A is overdue so I would change it
to red and all the sheets with part A on them would change to red. I hope
this makes sense.
Thanks in advance