Change Colour is Date Surpassed

[That's Confidential]

I have a date in a specific cell. If the actual today's date is greater than
that of the date in the specific cell, then I would like that cell colour to
change red.

For example, today is the 10th May. If the date in cell A1 is 9th May, then
I would like the cell colour to change to red.

Thanks in advance

 

[DNF Karran]

Select the cells you want to apply the formatting to and select from th
toolbar "format"/"Conditional Formatting" and set it to

Cell value is
less than
=TODAY()

and set up the format you want to give it.

Dunca

 

[Earl Kiosterud]

Joe,

You can use Format - Conditional formatting - Formula is:

=A2 < TODAY()

First select the cells, and substitute the address of the active (white)
cell.