Change color of a field when passed todays date

Purpose: Change color of the field in a column when passed a date.

COLUMN filled with rows with dates.
When a date is passed the background should change color.
Is that possible? Is a makro needed?

Could also the header flash in order to give recognition to check?
Any ideas/proposals?

SEALPINO

Conditional Formatting is how I would do this.

1. Select the date list, and click Conditional Formatting > New Rule under Home tab.
2. In the New Formatting Rule dialog box, you need to:

A. In the Select a Rule Type section, select Format only cells that contain.

B. Select Cell Value in the first Format only cells with drop-down list.

C. Select greater than in the second Format only cells with drop-down list.

D. In the third Format only cells with drop-down list, enter =TODAY().

E. Click the Format button.

3. In the Format Cells dialog box, specify a background color for highlighting the later dates, and then click the OK button.
4. When it returns to the New Formatting Rule dialog box, click OK.

Correction in conditional formatting.
>Cell Value > Less than or equal to
Enter :

Formula:

Please Login or Register  to view this content.

format "Red" color
Second : Format only cell with : Select "Blank" format "white" color.
File attach
for blinking you need vba macro.