Carrying format with cell reference to another sheet.
 

In my spreadsheet column headings are days and row headings are group
titles. Each group goes through different classes each day. It is
easiest to coordinate which group attends each class with the groups
stacked as described but it is harder for the group leaders to print
the calendar because it is so long. I have created formulas to bring
the data into a traditional calendar format on an adjacent sheet but
the formatting does not follow. Is there a way to force the formatting
to follow. The formula currently stands as: =IF('Sync Matrix'!
CN11,'Sync Matrix'!CN1,"")

Carrying format with cell reference to another sheet.
 

Hi,

You could either create a macro or you could create a custom function, both
in VBA.

Outside of VBA I don't think this is possible.
--
Cheers,
Shane Devenshire


" wrote:

In my spreadsheet column headings are days and row headings are group
titles. Each group goes through different classes each day. It is
easiest to coordinate which group attends each class with the groups
stacked as described but it is harder for the group leaders to print
the calendar because it is so long. I have created formulas to bring
the data into a traditional calendar format on an adjacent sheet but
the formatting does not follow. Is there a way to force the formatting
to follow. The formula currently stands as: =IF('Sync Matrix'!
CN11,'Sync Matrix'!CN1,"")