> .. 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?
Similar Threads
