Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding dates within a date range | Excel Worksheet Functions | |||
How to set up past due notices based on dates | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) |