Change Colour is Date Surpassed

  • Thread starter That's Confidential
  • Start date
T

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
 
D

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
 
E

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.
 
Top