View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default 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