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?