I have an excell spreadsheet that contains several work books. if I make a
change in the first workboot (master) I would like that change to happen in
each of the other workbooks where the master cell is referenced. Example:
I worksbooks A B C D E F, If I change the color of a cells contents in A4
then I would like that change to appear in any of the other workboot that
reference A4

In workbook B for cell C5 I have a link that looks like this =A!A$