first select the whole range you want the conditional format to apply to not
just first cell - when you do the formula for first cell take $ off and check
the stop when - you won't need to copy the format - it will be automatic

so, for example, my conditional format looks like this
Cell value <D$14 applieds to $D$18:$0$18 check the stop if true box

was driving me crazy, until I quit trying to COPY the format like in old
excel and used the applies to box to tell it the range to apply to and took $
off my $d$14 not the range


"Chetski" wrote:

The problem as I see it is not the conditional formatting, but Excel's
insistence on applying absolute references on the "Applies to" cells.

I selected a range of cells and applied a formula for conditional formatting
that works as expected on this selected range of cells. Yet when I try to
copy this rule to other rows, as previously noted, it just increases the
range of cells that gets affected by it. I want to apply this same rule as a
separate rule to a different row.

Is this possible? If so, please tell me how?

"reylon" wrote:

Are you sure you resolved? If I copy and paste conditional formatting in a
single cell it goes very well, but if I copy on a multiple cells I had the
problem that you described and the $ doesn't works (doesn' change the number
of row but use a range). Who can help me? Thanks

"spai461" wrote:

RESOLOVED
The problem I was having had nothing to do with cell references; it was a
logic error. Relative refs work fine in conditional formatting formulae.