Conditional formatting.. how do I copy cells?

[Guest]

I have made a conditional format... changes a cell red after 3 days.. works
great... but when I copy it to the line below.. by dragging or by doing a
past special.. it counts from the original date in the 1st line not the
second example.

a1=06/01/05 a2=06/03/05 cell is red... I drag and drop to cell B1 06/02/05
but cell b2 turns red on 06/03/05 as it is reading date from cell a1... any
thoughts?

 

[Bob Phillips]

Sounds like you have an absolute formula, like

=$A$1<TODAY()-3

If so, change to

=A1<TODAY()-3

 

[Guest]

Worked like a charm!!!!!

Thanks Bob!!!

Sounds like you have an absolute formula, like

=$A$1<TODAY()-3

If so, change to

=A1<TODAY()-3