Conditional formatting.. how do I copy cells?
 

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?

Sounds like you have an absolute formula, like

=$A$1<TODAY()-3

If so, change to

=A1<TODAY()-3

--
HTH

Bob Phillips

"raven_guy" wrote in message
...
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?

Worked like a charm!!!!!

Thanks Bob!!!

"Bob Phillips" wrote:

Sounds like you have an absolute formula, like

=$A$1<TODAY()-3

If so, change to

=A1<TODAY()-3

--
HTH

Bob Phillips

"raven_guy" wrote in message
...
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?