View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default 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