I am sure that there is a simple way to do this but I am not sure how.
I have a master worksheet where I have a whole bunch of data. I have other sheets with cells that point to the master sheet (i.e. sheet1 Cell A4 has formula ='Master'!H4). I want the formatting of Sheet1 cells A4 to be linked to the formatting of 'Master'!H4. Can I do this without having to setup conditional formatting on EVERY single page?
I have a master worksheet where I have a whole bunch of data. I have other sheets with cells that point to the master sheet (i.e. sheet1 Cell A4 has formula ='Master'!H4). I want the formatting of Sheet1 cells A4 to be linked to the formatting of 'Master'!H4. Can I do this without having to setup conditional formatting on EVERY single page?