Expired Date Formula

[Guest]

Does anyone know if Excel has a formula that will highlight an expired date
in red based on the current date? Example. Start Date = 1/4/04 and End Date
= 1/3/05. Today = 1/4/05 therefore the End Date has now expired and I would
like that to show up in red text in order to flag expired dates. Any
suggestions? Thanks Donna

 

[Guest]

you can use conditional formating to do that. no formula
needed. high light the column that the expired date may be
in then format>conditional format
enter the following:

first box second box third box
cell value is less than =today()

click the format button and set color to red.

good luck

 

[Guest]

Select the cell with the end date, assume it is A2, do format>conditional
formatting, formula is

=$A$2<TODAY()

click the format button and select a red font, click OK twice

Regards,

Peo Sjoblom

 

[Guest]

The conditional formatting worked. Thanks guys!!!!