How can I write a formula or an argument to highlight a date when.

saffield · Feb 24, 2005

it is past the current date

Jason Morin · Feb 24, 2005

=IF(A1<TODAY(),"Past Due","")

where A1 holds the date.

HTH
Jason
Atlanta, GA