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

Hello!

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.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion