Hi.

I'm trying to use condiational formatting in excel 2010 to do the following.

I have column with different dates
2008-04-22
2012-07-30
2010-01-23
etc

I want to change the background color if the date in each cell reaches a certain age.
For instance. If $A$1 is a older then a year, change background color to red.
I've made this work in ONE cell doing this.
I've made a conditional formatting with the follow formula
=Today()-$A$1>365 and changed background color.

However I don't know how to make this work in every row. I've tried copying this by dragging the corner of the cell downwards. no success. I've tried copying the format of the cell and paste it, but that doesn't copy this format.
I want to easily apply this to every row so that it automatically changes this to
=Today()-$A$2>365
=Today()-$A$3>365
=Today()-$A$4>365

How do I do that? Should I use the conditional formatting differently?
As it is now, I have to manually add a new rule for every row, and I have several hundreds.
Feels like this is easily fixed, but I'm totally new to excel.

thanks in advance.

hi,

1. select ALL the cells you want Conditionally Formatted

2. activate the CF Wizard

3. the TOP-LEFT-CELL/ROW of you selection is the frame of reference.

so assuming that the TOP-LEFT-CELL/ROW is A2

=Today()-$A2>365

Your formula will propagate to each row.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

I tried that the first time, but I didn't recieve any color.
It led me to believe that the method was wrong.
I wrote
=Today()-$A2>365
When I checked the rules again Excel had put the formula in quotas for some weird reason.
="Today()-$A2>365"

When I deleted them it worked like a charm.

Thanks *star*