Carrying over background color to another worksheet
Have you tried the Format Painter? Highlight a column in the original
sheet which is also used in the derived sheet, click the format painter
icon, click the tab for the derived sheet and click the row 1 cell of
the appropriate column. I can't quite remember off-hand, but I don't
think it adjusts column widths.
Hope this helps.
Pete
|