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
.