From within Excel 2007, can I export a set of conditional formatting rules
and then import them into another worksheet?

On Sheet "A" I've got about 12 conditional formatting rules. The rules
color certain cells based on whether a certain string of text is in the cell,
ex: HToH. I'd like for the same results in color change in the cell to
appear on Sheet "B".

I don't want to have to create the rules all over again for each sheet. The
thought of needing to edit the rules in future would be terrifying.

Thanks,
Chadwill

Hi

Click on the small cell with a triangle, above row numbers. This will
select the whole sheet.
CopyMove to Sheet2Paste SpecialFormats

--
Regards

Roger Govier


"Chadwill" wrote in message
...
From within Excel 2007, can I export a set of conditional formatting
rules
and then import them into another worksheet?

On Sheet "A" I've got about 12 conditional formatting rules. The
rules
color certain cells based on whether a certain string of text is in
the cell,
ex: HToH. I'd like for the same results in color change in the cell
to
appear on Sheet "B".

I don't want to have to create the rules all over again for each
sheet. The
thought of needing to edit the rules in future would be terrifying.

Thanks,
Chadwill

Which version of Excel is that, Roger?
On Excel 2003 the only thing that I could see which might be described as a
"small cell with a triangle, above row numbers" is the name box, and that
doesn't select the whole sheet.
On my version, to select the whole sheet one needs to click in the square in
the top left-hand corner (above the row 1 and to the left of the column A
labels), or alternatively Control A will select the whole sheet.
--
David Biddulph

"Roger Govier" wrote in message
...
Hi

Click on the small cell with a triangle, above row numbers. This will
select the whole sheet.
CopyMove to Sheet2Paste SpecialFormats

--
Regards

Roger Govier


"Chadwill" wrote in message
...
From within Excel 2007, can I export a set of conditional formatting
rules
and then import them into another worksheet?

On Sheet "A" I've got about 12 conditional formatting rules. The rules
color certain cells based on whether a certain string of text is in the
cell,
ex: HToH. I'd like for the same results in color change in the cell to
appear on Sheet "B".

I don't want to have to create the rules all over again for each sheet.
The
thought of needing to edit the rules in future would be terrifying.

Thanks,
Chadwill

I believe he was referring to Excel 2007 which is what I'm using but I don't
think I specified that.
Chad
****************

"David Biddulph" wrote:

Which version of Excel is that, Roger?
On Excel 2003 the only thing that I could see which might be described as a
"small cell with a triangle, above row numbers" is the name box, and that
doesn't select the whole sheet.
On my version, to select the whole sheet one needs to click in the square in
the top left-hand corner (above the row 1 and to the left of the column A
labels), or alternatively Control A will select the whole sheet.
--
David Biddulph

"Roger Govier" wrote in message
...
Hi

Click on the small cell with a triangle, above row numbers. This will
select the whole sheet.
CopyMove to Sheet2Paste SpecialFormats

--
Regards

Roger Govier


"Chadwill" wrote in message
...
From within Excel 2007, can I export a set of conditional formatting
rules
and then import them into another worksheet?

On Sheet "A" I've got about 12 conditional formatting rules. The rules
color certain cells based on whether a certain string of text is in the
cell,
ex: HToH. I'd like for the same results in color change in the cell to
appear on Sheet "B".

I don't want to have to create the rules all over again for each sheet.
The
thought of needing to edit the rules in future would be terrifying.

Thanks,
Chadwill

Hi David

That was in XL2007, which the OP did mention in his first post.
You are quite right, in XL2003 it is the square above row 1 and left of
column A
In XL2003 you need to type Ctrl +A twice to select the sheet.

--
Regards

Roger Govier


"David Biddulph" wrote in message
...
Which version of Excel is that, Roger?
On Excel 2003 the only thing that I could see which might be described
as a "small cell with a triangle, above row numbers" is the name box,
and that doesn't select the whole sheet.
On my version, to select the whole sheet one needs to click in the
square in the top left-hand corner (above the row 1 and to the left of
the column A labels), or alternatively Control A will select the whole
sheet.
--
David Biddulph

"Roger Govier" wrote in message
...
Hi

Click on the small cell with a triangle, above row numbers. This will
select the whole sheet.
CopyMove to Sheet2Paste SpecialFormats

--
Regards

Roger Govier


"Chadwill" wrote in message
...
From within Excel 2007, can I export a set of conditional formatting
rules
and then import them into another worksheet?

On Sheet "A" I've got about 12 conditional formatting rules. The
rules
color certain cells based on whether a certain string of text is in
the cell,
ex: HToH. I'd like for the same results in color change in the cell
to
appear on Sheet "B".

I don't want to have to create the rules all over again for each
sheet. The
thought of needing to edit the rules in future would be terrifying.

Thanks,
Chadwill

I did as you instructed. But it messed that sheet up totally. All I want to
copy over is the conditional formatting RULES, not the formatting itself.

Any other ideas?

Chad
**************************

"Roger Govier" wrote:

Hi

Click on the small cell with a triangle, above row numbers. This will
select the whole sheet.
CopyMove to Sheet2Paste SpecialFormats

--
Regards

Roger Govier


"Chadwill" wrote in message
...
From within Excel 2007, can I export a set of conditional formatting
rules
and then import them into another worksheet?

On Sheet "A" I've got about 12 conditional formatting rules. The
rules
color certain cells based on whether a certain string of text is in
the cell,
ex: HToH. I'd like for the same results in color change in the cell
to
appear on Sheet "B".

I don't want to have to create the rules all over again for each
sheet. The
thought of needing to edit the rules in future would be terrifying.

Thanks,
Chadwill

This goes for more then just CF.

Create and format SheetA exactly as you want your other sheets to duplicate
.... of course, minus the actual data.

With the SheetA tab selected,
hold down <Ctrl,
click and drag the SheetA tab to the right or left,
release the mouse *first*, then the <Ctrl.

You now have an *exact* copy of the original sheet, with a "2" appended
after the name.
Rename it, and you're all set with an exact copy!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Chadwill" wrote in message
...
I did as you instructed. But it messed that sheet up totally. All I want
to
copy over is the conditional formatting RULES, not the formatting itself.

Any other ideas?

Chad
**************************

"Roger Govier" wrote:

Hi

Click on the small cell with a triangle, above row numbers. This will
select the whole sheet.
CopyMove to Sheet2Paste SpecialFormats

--
Regards

Roger Govier


"Chadwill" wrote in message
...
From within Excel 2007, can I export a set of conditional formatting
rules
and then import them into another worksheet?

On Sheet "A" I've got about 12 conditional formatting rules. The
rules
color certain cells based on whether a certain string of text is in
the cell,
ex: HToH. I'd like for the same results in color change in the cell
to
appear on Sheet "B".

I don't want to have to create the rules all over again for each
sheet. The
thought of needing to edit the rules in future would be terrifying.

Thanks,
Chadwill

I specifically do not want an exact copy. I specifically want the formatting
to be different than the other page, except for the conditional formatting
RULES.

All I want to copy over is the conditional formatting RULES, nothing else.

It seems that there is a disconnect in trying to describe and understanding
what I am wanting to accomplish but I know of no other way to express it
except maybe this way:

Very simple, nothing about the two pages are to be similar, except:
1. the conditional formatting rules.

consequently:

2. in the chance that a specific value in a cell on one page is the same as
a cell on the other page, that having the same conditional formatting rules
on both pages would color both cells the same color.

**************************

"Ragdyer" wrote:

This goes for more then just CF.

Create and format SheetA exactly as you want your other sheets to duplicate
.... of course, minus the actual data.

With the SheetA tab selected,
hold down <Ctrl,
click and drag the SheetA tab to the right or left,
release the mouse *first*, then the <Ctrl.

You now have an *exact* copy of the original sheet, with a "2" appended
after the name.
Rename it, and you're all set with an exact copy!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Chadwill" wrote in message
...
I did as you instructed. But it messed that sheet up totally. All I want
to
copy over is the conditional formatting RULES, not the formatting itself.

Any other ideas?

Chad
**************************

"Roger Govier" wrote:

Hi

Click on the small cell with a triangle, above row numbers. This will
select the whole sheet.
CopyMove to Sheet2Paste SpecialFormats

--
Regards

Roger Govier


"Chadwill" wrote in message
...
From within Excel 2007, can I export a set of conditional formatting
rules
and then import them into another worksheet?

On Sheet "A" I've got about 12 conditional formatting rules. The
rules
color certain cells based on whether a certain string of text is in
the cell,
ex: HToH. I'd like for the same results in color change in the cell
to
appear on Sheet "B".

I don't want to have to create the rules all over again for each
sheet. The
thought of needing to edit the rules in future would be terrifying.

Thanks,
Chadwill

The CF "rules" are actually formulas that equate to TRUE or FALSE, where the
return of TRUE will enable the formatting as prescribed in the CF.

Now ... are you looking to copy the formulas of the CF, *BUT NOT* the
formatting that was selected on the previous sheet?

So that say, the *same* condition in B2 on Sheet1 and Sheet2 will invoke
*different* formats (colors) on each individual sheet?

OR ... are you looking to exactly copy *only* the CF's, and not all the
other surrounding formats in/on the other neighboring cells?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Chadwill" wrote in message
...
I specifically do not want an exact copy. I specifically want the
formatting
to be different than the other page, except for the conditional formatting
RULES.

All I want to copy over is the conditional formatting RULES, nothing else.

It seems that there is a disconnect in trying to describe and
understanding
what I am wanting to accomplish but I know of no other way to express it
except maybe this way:

Very simple, nothing about the two pages are to be similar, except:
1. the conditional formatting rules.

consequently:

2. in the chance that a specific value in a cell on one page is the same
as
a cell on the other page, that having the same conditional formatting
rules
on both pages would color both cells the same color.

**************************

"Ragdyer" wrote:

This goes for more then just CF.

Create and format SheetA exactly as you want your other sheets to
duplicate
.... of course, minus the actual data.

With the SheetA tab selected,
hold down <Ctrl,
click and drag the SheetA tab to the right or left,
release the mouse *first*, then the <Ctrl.

You now have an *exact* copy of the original sheet, with a "2" appended
after the name.
Rename it, and you're all set with an exact copy!
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-


"Chadwill" wrote in message
...
I did as you instructed. But it messed that sheet up totally. All I
want
to
copy over is the conditional formatting RULES, not the formatting
itself.

Any other ideas?

Chad
**************************

"Roger Govier" wrote:

Hi

Click on the small cell with a triangle, above row numbers. This
will
select the whole sheet.
CopyMove to Sheet2Paste SpecialFormats

--
Regards

Roger Govier


"Chadwill" wrote in message
...
From within Excel 2007, can I export a set of conditional
formatting
rules
and then import them into another worksheet?

On Sheet "A" I've got about 12 conditional formatting rules. The
rules
color certain cells based on whether a certain string of text is
in
the cell,
ex: HToH. I'd like for the same results in color change in the
cell
to
appear on Sheet "B".

I don't want to have to create the rules all over again for each
sheet. The
thought of needing to edit the rules in future would be
terrifying.

Thanks,
Chadwill

Hi Chad

I only tested with 1 rule in place, and it worked fine.
I can't see why it would be any different for multiple rules.
In my case formatted G12:H17 with the Conditional format =$A$1=1 and
Fill colour Yellow.
I selected the whole sheet (either the triangle cell top left, or Ctrl +
A (once only required in XL2007))
Copy
Move to cell A1 of Sheet3Paste SpecialFormats
Type a 1 in A1, cells G12:H17 turn yellow.

Nothing gets altered/destroyed/messed up in Sheet2


--
Regards

Roger Govier


"Chadwill" wrote in message
...
I did as you instructed. But it messed that sheet up totally. All I
want to
copy over is the conditional formatting RULES, not the formatting
itself.

Any other ideas?

Chad
**************************

"Roger Govier" wrote:

Hi

Click on the small cell with a triangle, above row numbers. This will
select the whole sheet.
CopyMove to Sheet2Paste SpecialFormats

--
Regards

Roger Govier


"Chadwill" wrote in message
...
From within Excel 2007, can I export a set of conditional
formatting
rules
and then import them into another worksheet?

On Sheet "A" I've got about 12 conditional formatting rules. The
rules
color certain cells based on whether a certain string of text is in
the cell,
ex: HToH. I'd like for the same results in color change in the
cell
to
appear on Sheet "B".

I don't want to have to create the rules all over again for each
sheet. The
thought of needing to edit the rules in future would be terrifying.

Thanks,
Chadwill

Yes, you can export a set of conditional formatting rules from one worksheet and import them into another worksheet in Excel 2007. Here are the steps to do so:

1. Open the worksheet that contains the conditional formatting rules you want to export.
2. Select the cells that have the conditional formatting rules you want to export.
3. Click on the "Conditional Formatting" button in the "Home" tab of the ribbon.
4. Select "Manage Rules" from the drop-down menu.
5. In the "Manage Rules" dialog box, select the rule you want to export and click on the "Export" button.
6. Choose a location to save the exported file and give it a name.
7. Repeat steps 5 and 6 for each rule you want to export.
8. Open the worksheet where you want to import the conditional formatting rules.
9. Select the cells where you want to apply the conditional formatting rules.
10. Click on the "Conditional Formatting" button in the "Home" tab of the ribbon.
11. Select "Manage Rules" from the drop-down menu.
12. In the "Manage Rules" dialog box, click on the "Import" button.
13. Navigate to the location where you saved the exported files and select the file you want to import.
14. Repeat steps 12 and 13 for each file you want to import.
15. Click "OK" to close the "Manage Rules" dialog box.

Your imported conditional formatting rules should now be applied to the selected cells in the new worksheet.