Use formatconditional format and formula is
=TODAY()cell_with_due_date
select maybe a red background for past due date
--
Regards,
Peo Sjoblom
(No private emails please)
"melarmor" wrote in message
...
I'm creating a bill payment worksheet. Is there a way to cause past due -
due dates to flag themselves in my worksheet and remind me that that the
monthly due date has passed?
|