Conditional format based on date Excel 2003

Question

Hi,

I need to have D3 title change colour when the date in E6 is older than 1 year. How do I do this?

I also need to copy this through the entire sheet for 60 sections. Do i do it per cell?

Thanks

Answer 1

Thanks but this does not work when used as second condition. It works on its own but not with the other format.

Also couls you explain the second part please?

Answer 2

First part

Select cell D3. Go to conditional formatting and there you should use this formula in new rule.

=ISBLANK(E3)

Second part:  do not add new row. Work with the model " a row is a  a record ". So add new columns for the news data.

best wishes

Answer 3

Any ideas?

Answer 4

Fantastic thanks.

I also need D3 to show red if E3 is blank. 

Also need to add row beneath so D3 will show if E4 is over year or blank, then E5, etc

Item	Example (cell d3)
Item no.	1
Name	D. Palbras
Date out, Date in.	15/06/11	01/07/11 (cell e3)

In the next row I will add Name, Next row Date out  and in.

Its to keep track of items. Who has them, When loaned out, When returned.

Red to show that an item is out on loan. Green to show Item is over year since returned.

I add rows to heep track of who had item in the past and for how long.

Thanks

Answer 5

Select cell D3. Go to conditional formatting and there you should use this formula in new rule.

=E6<TODAY()-365

Select formatting of your choice.

To use same conditional formatting at other cells. Copy Cell D3, select cells at destination and use paste special while Radio button Formatting is selected.