Conditional Formating For a Date
 

I would like to set a conditional format for a date, day-month-2 digit year.
If I enter any give date in a cell, and once that date exceeds 2 yrs, then I
would like the text or the cell to be highted to a color.
Thanks

Conditional Formating For a Date
 

Use the following formula in FORMULA is
=(A1-Today())730

assuming your dates are in Col A

"Dan" wrote:

I would like to set a conditional format for a date, day-month-2 digit year.
If I enter any give date in a cell, and once that date exceeds 2 yrs, then I
would like the text or the cell to be highted to a color.
Thanks

Conditional Formating For a Date
 

Will this still work even if they are not todays dates. Some of these dates
go back a yaer or so.

"Sheeloo" wrote:

Use the following formula in FORMULA is
=(A1-Today())730

assuming your dates are in Col A

"Dan" wrote:

I would like to set a conditional format for a date, day-month-2 digit year.
If I enter any give date in a cell, and once that date exceeds 2 yrs, then I
would like the text or the cell to be highted to a color.
Thanks

Conditional Formating For a Date
 

Yes. Today() gives you the today's date and then compares it with the date in
A1

NOTE: I gave you the wrong direction.
Pl. use
=(Today() - A1)730

Use 731 Iinstead of 730) if you want to take care of leap year...
"Dan" wrote:

Will this still work even if they are not todays dates. Some of these dates
go back a yaer or so.

"Sheeloo" wrote:

Use the following formula in FORMULA is
=(A1-Today())730

assuming your dates are in Col A

"Dan" wrote:

I would like to set a conditional format for a date, day-month-2 digit year.
If I enter any give date in a cell, and once that date exceeds 2 yrs, then I
would like the text or the cell to be highted to a color.
Thanks