Hi David

Excel will be able to identify the current date. So you dont need to enter
the current date to the header cell. Try the below in cell A1 of a fresh
workbook and feedback

From menu FormatConditional Formatting

In Condition1 select 'Formula Is' and enter
=DATEDIF(A1,TODAY(),"y")0
and select red color from FormatPattern

In Condition2 select 'Formula Is' and enter
=DATEDIF(A1,TODAY(),"y")=0
and select green color from FormatPattern

If this post helps click Yes
---------------
Jacob Skaria


"DavidM" wrote:

Today's date will be manually entered in to a header cell.
The worksheet contains the dates that customers last purchased from me.
How can I change the colour of the customer dates (and other details) eg. To
Red if older than a year, to Green if less than a year?
Apologies if this has a simple/obvious solution!
Many thks,
--
DavidM