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

you can use conditional formating to do that. no formula
needed. high light the column that the expired date may be
in then formatconditional 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

-----Original Message-----
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
.

Select the cell with the end date, assume it is A2, do formatconditional
formatting, formula is

=$A$2<TODAY()

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

Regards,

Peo Sjoblom


"Donna in Elkin, NC" wrote:

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

The conditional formatting worked. Thanks guys!!!!

"Donna in Elkin, NC" wrote:

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