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
|