Past Due - Due Dates

[Guest]

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?

 

[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)

 

[Guest]

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.

 

[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)