Past Due - Due Dates

M

melarmor

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?
 
P

Peo Sjoblom

Use format>conditional 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)
 
M

melarmor

It didn't quite work ... Thank you for your help ... I'm sure its operator
error. Nothing changed after carefully following your very excellent
instructions.
 
P

Peo Sjoblom

OK, put 06/10/05 in A1, assume that's the due date

select A1, in the menu click format>conditional formatting, from dropdown
select formula is
click in the formula box and type or copy and paste

=A1<TODAY()

click the format button, select patterns, select a red patter (something
that stands out) and click OK twice
now change the date in A1 to 05/31/05

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top