Conditional Formatting in Excel

[Mightierthan]

Hopefully there will be an Excel whizz out there who can help me.
I want to use Conditional Formatting for a range of cells that have to be in date format. I want to apply formatting when each date is 3 years in the past. I have tried the 'less than' and then typing varieties of "today-1095" etc, but to no avail.
Can anyone advise on the correct formula? Cheers

 

[rest have risen above me]

I can't remember exactly but you have to do something with the date to convert to a number do the sum and then convert back. I'm racking my brains at the mo Excel treats dates as a finite figure when its manipulating them and its this feature that you use. Will get back to you.

 

[SirSaltyHelmet]

google Excel formulae. Some geeks have them ready made for you.

 

[Nec Aspera Terrent]

Try...

Cell Value is less than =TODAY()-1095

 

[Mightierthan]

Try...

Cell Value is less than =TODAY()-1095

Got it: =NOW()-1095
Thanks N A T

 

[rest have risen above me]

Try...

Cell Value is less than =TODAY()-1095

Was going to say that ..honest...DT_Xtremez_30: