Date Reminder

[George]

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

 

[Bob Umlas]

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.

 

[George]

Thanks - That works but it gives me 60 days prior to and 60 days after
today's date.

George