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.

"George" wrote in message
...
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