Excel date & font question

I want to do the following:
I enter a date in col A1 and Each time I open a worksheet the current date in colB1 is compare and when the date has lapse I want the date in col A1 to flash in red or any other column. Can this be done?