conditional formatting or formulae to show elapsed dates

[Jo]

I have a large sheet showing dates of expiry. I want to see at a glance
which have elapsed.

 

[JC]

Assuming date in B2 try the following:
=IF((B2-TODAY()<0),"Expired", "OK")

 

[Jo]

Brilliant! Thanks JC

Assuming date in B2 try the following:
=IF((B2-TODAY()<0),"Expired", "OK")

 

[Teethless mama]

=IF(TODAY()>B2,"Expired","OK")