Thread: conditional formatting or formulae to show elapsed dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default conditional formatting or formulae to show elapsed dates
=IF(TODAY()B2,"Expired","OK")


"Jo" wrote:

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