And for the highlight, use conditional formatting...Cell value is equal to
"Expired"...and set the desired format for the highlight.

Mike H wrote:
With your expiry date in a1 try this

=IF(TODAY()A1,"Expired",A1-TODAY())

Mike

"sibboo" wrote:

Need help with a formula that will Count down the number of days before a
contract will expire. When the date is Expired, I need it to say "EXPIRED",
and highlight the cell. Can anyone help me with this?