Copying rules set on a range of cells
 

I have selected a range of cells in a row and created a rule to change text
color if conditions are met. I have multiple rows to which I wish to apply
this same rule. However, when I try to copy this rule it just increases the
range of cells that it affects.

Methinks it may be due to Excel applying absolute references to the "Applies
to" cells which cannot be removed.

Is it possible to copy this rule to a different set of cells? If so, can
you please tell me how?

Copying rules set on a range of cells
 

Taker a look at this:
http://www.contextures.com/xlCondFormat03.html

This too:
http://www.cpearson.com/excel/relative.aspx

Does that help?

--
RyGuy


"Chetski" wrote:

I have selected a range of cells in a row and created a rule to change text
color if conditions are met. I have multiple rows to which I wish to apply
this same rule. However, when I try to copy this rule it just increases the
range of cells that it affects.

Methinks it may be due to Excel applying absolute references to the "Applies
to" cells which cannot be removed.

Is it possible to copy this rule to a different set of cells? If so, can
you please tell me how?

Copying rules set on a range of cells
 

.. it may be due to Excel applying absolute references to the "Applies
to" cells which cannot be removed.

True, that sometimes that's the "annoying" default applied by Excel when you
do point n click in dialogs. But you could always click inside the dialog and
change the references to suit (eg remove the $ signs, etc)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
---
"Chetski" wrote:
I have selected a range of cells in a row and created a rule to change text
color if conditions are met. I have multiple rows to which I wish to apply
this same rule. However, when I try to copy this rule it just increases the
range of cells that it affects.

Methinks it may be due to Excel applying absolute references to the "Applies
to" cells which cannot be removed.

Is it possible to copy this rule to a different set of cells? If so, can
you please tell me how?