Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 19th 19, 10:04 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2019
Posts: 1
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!

  #2   Report Post  
Old August 20th 19, 06:13 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,058
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving custom colors pj Excel Discussion (Misc queries) 0 January 21st 10 05:54 PM
Saving Customized Colors Christine Excel Discussion (Misc queries) 0 January 17th 08 05:37 PM
Custom Colors Keyrookie Excel Worksheet Functions 3 October 11th 07 04:34 PM
restoring default fill colors, & saving with a custom color scheme WiFiMike2006 Excel Discussion (Misc queries) 3 March 28th 07 06:37 PM
Keeping Worksheet tab colors when saving as web page massbayguy Excel Discussion (Misc queries) 0 July 7th 05 08:38 PM


All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017