Hello,

I’ve got the first three columns on sheet one formatted conditionally, and frozen. They are always the leading three columns on all following sheets in the workbook, and continue the color pattern, for example when I type “Conservation” in an empty cell in column B, it turns orange.

My intent, which I cannot figure out, is to be able to update the data in sheet one in these frozen columns, and have it update across all sheets, while keeping the source formatting; cell fill color, bold, and links. I’ve tried copy->paste as link for the column on the next sheets, but that doesn’t keep the formatting. I’ve also tried a few formulas that replicate the data accurately, but don’t keep the color coding, or the corresponding hyperlinks, for example.

Seems like this function should be hiding in plain sight, but I’m somewhat of an Excel newbie here, so please keep that in mind, if you’re kind enough to respond.

Thank you!

​Hello,I’ve got the first three columns on sheet one formatted conditionally, and frozen. They are always the leading three columns on all following sheets in the workbook, and continue the color pattern, for example when I type “Conservation” in an empty cell in column B, it turns orange.My intent, which I cannot figure out, is to be able to update the data in sheet one in these frozen columns, and have it update across all sheets, while keeping the source formatting; cell fill color, bold, and links. I’ve tried copy->paste as link for the column on the next sheets, but that doesn’t keep the formatting. I’ve also tried a few formulas that replicate the data accurately, but don’t keep the color coding, or the corresponding hyperlinks, for example.Seems like this function should be hiding in plain sight, but I’m somewhat of an Excel newbie here, so please keep that in mind, if you’re kind enough to respond.Thank you!  Read More

​