Can you update formatting on a master sheet from a formatting change on a related sheet?

[KB_Miner]

I have a workbook that has 13 identical sheets. One for each month, and one for the year end that sums all the data in the other sheets. My boss is asking me if it's possible that if someone highlights a value on one of the monthly sheets for that same cell to be highlighted in the year end sheet (and only in the year end sheet, not across all sheets). Would be nice if there could be a link on the yearly total sheet to the changed cell on the monthly sheet. Not sure on this one, so any ideas would be helpful.

 

[seguin85]

I have a workaround but may not be suitable for what your needs require. Anyways, what this code will do is always select the "Year End" page when you select any of the monthly sheets. So when you change the fill of a cell in the month tab it will also change it in the year end tab. Only problem with this is that if you enter values or change formula it will also change it in the year end tab.

Private Sub Worksheet_Activate()

Sheets("YearEnd").Select Replace:=False

End Sub

 

[FDibbins]

Formulas do not generally "see" formatting, and they cannot "pull-in" formatting from other cells, so you will need VBA for this