From: grizzly6969 on 14 May 2010 04:44 you are absolutely correct I didn't think of a leap year -- grizz "מיכאל (מיקי) אבידן" wrote: > Usually, Excel is used for precise calculations - therefor I don't think the > suggestion to reduce 1095 days (365*3) is a good idea because of some leap > years with 366 days [such as 2008]. > Micky > > > "grizzly6969" wrote: > > > say your date is in A15 ----conditional formal / formula is > > =and(A15 > and format to your colour > > -- > > grizz > > > > > > "Teeny" wrote: > > > > > I have a column of dates and I want to highlight in red all dates that are > > > equal to and more than 3 years old > > > > > > For example if the date is 02/10/04 this should be highlighted in red. > > > > > > I would appriciate anyones help! From: Teeny on 14 May 2010 04:47 Thanks, this is similar to thow I have been doing it, however I need to subtract full years and not 365 days as I realised this does not account for leap years. "RonaldoOneNil" wrote: > Try setting the condition to > Cell Value is > Not Between > =TODAY() > =TODAY()-(365*3) > > "Teeny" wrote: > > > I have a column of dates and I want to highlight in red all dates that are > > equal to and more than 3 years old > > > > For example if the date is 02/10/04 this should be highlighted in red. > > > > I would appriciate anyones help! From: Jacob Skaria on 14 May 2010 04:49 Please check your other post. -- Jacob (MVP - Excel) "Teeny" wrote: > I have a column of dates and I want to highlight in red all dates that are > equal to and more than 3 years old > > For example if the date is 02/10/04 this should be highlighted in red. > > I would appriciate anyones help!