View Single Post
  #2   Report Post  
Old August 20th 19, 06:13 PM posted to microsoft.public.excel.misc
GS[_6_] GS[_6_] is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,164
Default Saving Custom Colors for Continuous Use


I have seen several threads about saving a custom color scheme for new
spreadsheets and am able to do that without issues. The problem I am
having is that I update and edit a set spreadsheet every morning that is
pulled from an Access report. Is there a way to save the custom colors
so I may continually use them on a spreadsheet sent to me from an
outside source? Every morning I have to add the custom colors used to
coordinate all the information across previous reports. I am currently
using Excel 2013 version.

Thank you in advance for your help!

You could save your color scheme on a template sheet, then import from the set
spreadsheet into your template sheet. (Copy/pasteValues) If you do it once
using the macro recorder you'd be able to repeat later by running the macro.


Free usenet access at
Classic VB Users Regroup!