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