Hopefully, someone can help me with this. I'm not even sure what to call it, so I'm having a hard time searching the questions already asked. I'm using Excel 2003.

I have a workbook with a large spreadsheet, and several smaller "summary" spreadsheets that do nothing that reference the larger one. In other words, all of the information to populate the cells goes in the first spreadsheet. The next 3 spreadsheets all refer back to it so that we can print out summary tables based only on certain topics.

Do do this, I essentially have the following formula in each cell of the summary spreadsheets: ='Master Table'!C6

Actually, since I don't want a "0" if the cell is blank, I used =IF(('Master Table'!C6=""),"",('Master Table'!C6))

Anyway, any changes to the data MUST be put in the master table. To help keep track of things, I often highlight cells (e.g. yellow = update this cell)

Is there a way to get the summary table to automatically highlight the cell I highlighted in the master table? Like some sort of conditional formatting that reads "format of this cell = format of that cell"?

Anything I do would need to be within the pointing and clicking or formula realm of Excel - I do not know how to do any Excel programming.

Thanks,
Laura