Once you have a custom color palette set up in Excel, see how you can easily copy it to other existing workbooks. Episode 528 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Welcom back to the MrExcel netcast.
I'm Bill Jelen.
This week, we've been talking about color palettes.
I went through and I went through the tedious process of creating a color palette with 56 different shades of green.
Let's say the Green's my favorite color and this is great.
I've saved this maybe, I saved it as a template like I mentioned yesterday.
But then I get a workbook from someone else.
Someone sends me a workbook, and I really want to get my green colors into this workbook.
But unfortunately because the other person is just using the default palette.
I'm just getting the regular 56 colors, that we always get.
Well, what we have to do is go to tools, options and go to the color tab and there is a section down here at the bottom that says, copy colors from.
It'll copy from any other open workbook.
So, we could open our green color workbook, say that we want to copy from there click [ ok ] and now, we've easily copied our palette from one existing workbook.
It has to be open to another workbook.
Now, I saw a bit of code on the internet the other day, which really looks interesting.
I'm gonna go back to my green color workbook, and I'm going to create a brand new macro.
So, we'll hit [ alt F11 ], to go to the visual basic editor, and I want to insert a module in the green color workbook.
So, I'll click on that workbook in the project explorer, say insert module and I'm just going to create a one-line macro.
I'll call it copy colors.
The idea is going to be that, I'm going to open the green color workbook in the background and I want to copy the colors to the current active workbook.
So, what we can say is active workbook dot colors equals this workbook dot colors this workbook, is the shortcut name for whatever workbook happens to be holding this macro.
We'll go back to Excel and the macros, dialog box.
I'll click copy colors, click options and assign this to a shortcut key, maybe [ ctrl J ] or something like that.
Click [ ok ].
So, what we have now, is a way to copy the palette from this green colors workbook to any other workbook that I open.
I just keep green colors open in the background.
I create a brand new workbook, you see that we have the wrong colors.
You'll see that I hit [ ctrl J ] and now all of a sudden my palate has the colors from the other workbook.
So, short little macro or tools options, colors, copy colors from, to bring the colors one workbook to another workbook.
Now, so far this week.
We've been talking about the color palette in Excel 97 through 2003.
Tomorrow, we're going to take a look at the great new changes in Excel 2007 with their color palettes.
Thanks for stopping by, we'll see you next time for another netcast from MrExcel.
I'm Bill Jelen.
This week, we've been talking about color palettes.
I went through and I went through the tedious process of creating a color palette with 56 different shades of green.
Let's say the Green's my favorite color and this is great.
I've saved this maybe, I saved it as a template like I mentioned yesterday.
But then I get a workbook from someone else.
Someone sends me a workbook, and I really want to get my green colors into this workbook.
But unfortunately because the other person is just using the default palette.
I'm just getting the regular 56 colors, that we always get.
Well, what we have to do is go to tools, options and go to the color tab and there is a section down here at the bottom that says, copy colors from.
It'll copy from any other open workbook.
So, we could open our green color workbook, say that we want to copy from there click [ ok ] and now, we've easily copied our palette from one existing workbook.
It has to be open to another workbook.
Now, I saw a bit of code on the internet the other day, which really looks interesting.
I'm gonna go back to my green color workbook, and I'm going to create a brand new macro.
So, we'll hit [ alt F11 ], to go to the visual basic editor, and I want to insert a module in the green color workbook.
So, I'll click on that workbook in the project explorer, say insert module and I'm just going to create a one-line macro.
I'll call it copy colors.
The idea is going to be that, I'm going to open the green color workbook in the background and I want to copy the colors to the current active workbook.
So, what we can say is active workbook dot colors equals this workbook dot colors this workbook, is the shortcut name for whatever workbook happens to be holding this macro.
We'll go back to Excel and the macros, dialog box.
I'll click copy colors, click options and assign this to a shortcut key, maybe [ ctrl J ] or something like that.
Click [ ok ].
So, what we have now, is a way to copy the palette from this green colors workbook to any other workbook that I open.
I just keep green colors open in the background.
I create a brand new workbook, you see that we have the wrong colors.
You'll see that I hit [ ctrl J ] and now all of a sudden my palate has the colors from the other workbook.
So, short little macro or tools options, colors, copy colors from, to bring the colors one workbook to another workbook.
Now, so far this week.
We've been talking about the color palette in Excel 97 through 2003.
Tomorrow, we're going to take a look at the great new changes in Excel 2007 with their color palettes.
Thanks for stopping by, we'll see you next time for another netcast from MrExcel.
