conditional formatting
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<today()-1095)
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!
|