Check your conditional formatting formula to see if there are dollar signs
"$" preceding the cell references.
The $ makes the cell reference "absolute".
The absence of the $ makes the cell reference "relative".

it's explained here
tls.calpoly.edu/guides/excel/excel_2.doc
Here's the relevant snip

Absolute references If you don't want Excel to adjust references when you
copy a formula to a different cell, use an absolute reference. For example,
if your formula multiplies cell A5 with cell C1 (=A5*C1) and you copy the
formula to another cell, Excel will adjust both references. You can create
an absolute reference to cell C1 by placing a dollar sign ($) before the
parts of the reference that do not change. To create an absolute reference
to cell C1, for example, add dollar signs to the formula as follows:
=A5*$C$1

Switching between relative and absolute references If you created a
formula and want to change relative references to absolute (and vice versa),
select the cell that contains the formula. In the formula bar, select the
reference you want to change and then press F4. Each time you press F4,
Excel toggles through the combinations: absolute column and absolute row
(for example, $C$1); relative column and absolute row (C$1); absolute column
and relative row ($C1); and relative column and relative row (C1). For
example, if you select the address $A$1 in a formula and press F4, the
reference becomes A$1. Press F4 again and the reference becomes $A1, and so
on.


HTH
Gloria










"Steve Westwood" <Steve a écrit dans le
message de news: ...
I am using Excel 2003

I am trying to add conditional format to a column of cells with the
condition refering to a date in the corresponding cell in the previous
column. Is there a way of copying this conditional formatting to other
cells
in the column and the formula progressing as it would if the cell had just
a
formula in it (i.e. +A1+B1 becomes =A2+B2 in the next row when copied
down).
Whenever and however I copy the cell the conditional formatting always
refers
to the original cell not the next one down.