Is it possible to save conditional formatting rules for reuse in a new workbook?

Question

I want to make some rules that I can haves saved that I can easily apply to new workbooks as needed. It's a pain doing it how I currently do where I'm always having to go back through and recreate these conditional format rules. If this is unclear please let me know and I'll try explaining better.

My apologies... so here is a better description of the issue.

I have values that I want to color code that come up all the time in documents I create. For instance, I might have a sample document like the following:

Jane       2.1
Steve      4.5
Caleb      4.4

I want to have the cells with the numbers formatted a certain way based on the numbers falling within a certain range. So each time this comes up in a document I end up created 7+ conditional rules for the 7 or more number ranges. These rules never change except for every 3 years or so. It would be nice to be able to have them save and then I can just use format painter or something to apply them to certain columns when creating a new document.

Hope this helps explain the situation!

Answer 1

You can use a template to save the all of the conditional formatting rules.

1. Start with a blank spreadsheet.
2. Add any content you want to appear in new spreadsheet.
3. Add the conditional formatting rules you want in each new spreadsheet.
4. Use Save As and choose Excel Template
5. When creating a new spreadsheet choose My templates and then the template you want.

Answer 2

It looks like you’ve got the answer right there in your question –– or am I missing something?  You can use “Format Painter” (in the “Clipboard” panel of the “Home” tab).

1. Create a file that has your chosen formats.  Save it.    ...    Later,
2. Create or open a new file with data.
3. Reopen your original file.
4. Click on a cell that has the format(s) that you want to use.
5. Click on “Format Painter”.
6. Switch over to the new file and click on the cell(s) to which you want to apply the format(s).

Following standard “Format Painter” semantics, if you want to copy a format (or a format collection) to multiple ranges, double-click on “Format Painter”.

Answer 3

record a macro,run it the next time you have to apply the conditional format.