Thread: How can I write a formula or an argument to highlight a date when.
View Single Post
  #1   Report Post  
Jason Morin
 
Posts: n/a
Default
=IF(A1<TODAY(),"Past Due","")

where A1 holds the date.

HTH
Jason
Atlanta, GA

-----Original Message-----
it is past the current date
.

Reply With QuoteReply With Quote