automatic formatting update

[daveyc18]

long shot here:

so i have a worksheet (lets call it A) linked to worksheet B.

whenever I update the formatting in worksheet B, is there a way that the formatting in worksheet A also gets updated? eg highlight cell A10 in worksheet A, and worksheet B also gets highlighted in cell A10.

 

[jasonb75]

Not on a cell by cell basis in the same way as a formula would work, for a continuous range you could use copy and pastespecial formats in a worksheet activate event.
I don't think that doing what you want with non continuous cells will be simple, which could explain the lack of replies to your question.

 

[daveyc18]

Not on a cell by cell basis in the same way as a formula would work, for a continuous range you could use copy and pastespecial formats in a worksheet activate event.
I don't think that doing what you want with non continuous cells will be simple, which could explain the lack of replies to your question.

ye I figured it'd be a long shot ...I know I could just copy and paste formats ...however ...this workbook template gets refreshed every month so all the highlights disappear on both worksheets ....so essentially the highlights are manual and change everything month

oh well

 

[jasonb75]

If you need to keep the existing formats and add more to it after the refresh then how about pasting to a blank sheet before refreshing?

 

[daveyc18]

process works like this ...every month I clear a worksheet called RAW and then copy and paste the new data to worksheet RAW (unaltered data as my team wants )....two other workbooks are linked to RAW ..why two? one is for month over month analysis and other for quarter over quarter...those two sheets have their highlights removed as it's a new month of data

then I do my manual analysis on the month over month tab, highlighting cells and rows accordingly . those same highlights should also appear on the quarter over quarter tab ..which is what I was originally asking about ...and fyi also need to do additional analysis (highlights) on quarter over quarter tab just to show that having that the quarter over quarter tab isn't redundant