Past Due - Due Dates
 

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?

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?

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" wrote:

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?

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

select A1, in the menu click formatconditional 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)


"melarmor" wrote in message
...
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" wrote:

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?