Date Reminder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I get the background of a cell to change color if the date entered is
within 60 days of todays date ?

Is there a way to make it flash ?

Thanks
 
Format/Conditional Formatting
change Cell Value is to Formula Is
enter
=ABS(A1-TODAY())<=60
click Format button, click Patterns tab, pick a color.
Change A1 to the cell containing the date.
 
Thanks - That works but it gives me 60 days prior to and 60 days after
today's date.

George
 
Back
Top