|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 22nd 12, 04:29 PM
|
|||
|
|||
How do I track next due date
Hi,
I conduct audits annually and want to highlight upcoming audit dates that I need to begin working on scheduling. I am working with the last audit date and need 4 months notice. I have tried to setup conditional formatting but get everything but what I want. Column E lists the last audit date: 8/10/11 (needs to highlight) 5/26/11 (needs to highlight) 4/6/12 11/2/11 Can anyone help?? Thanks! Laurie Last edited by LMDeWitt : May 22nd 12 at 04:46 PM. Reason: change title 
|
| Ads |
|
#2
May 22nd 12, 11:01 PM
|
|||
|
|||
Quote:
Easy enough to set up, but I need to know which version of Excel you're using as it differs slightly between them. S.
|
|
#3
May 23rd 12, 11:06 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I highlight past dates
> I conduct audits annually and want to highlight upcoming audit dates
> that I need to begin working on scheduling. I am working with the last > audit date and need 4 months notice. > > Column E lists the last audit date: > 8/10/11 (needs to highlight) > 5/26/11 (needs to highlight) > 4/6/12 > 11/2/11 One way is to select column E and use Format > Conditional Formatting with "Formula Is" =TODAY()>=DATE(YEAR(E1),MONTH(E1)+8,DAY(E1)) and click "Format" to select the desired highlighting. The 8 months is for a year (between audits) minus the 4 months' notice. Hope this helps.
|
|
#4
May 24th 12, 09:23 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I highlight past dates
Hi Laurie,
Am Tue, 22 May 2012 15:29:37 +0000 schrieb LMDeWitt: > Column E lists the last audit date: > 8/10/11 (needs to highlight) > 5/26/11 (needs to highlight) > 4/6/12 > 11/2/11 select column E => CF => Formula: =AND(E1>0,E1<TODAY()) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2
|
|
#5
May 24th 12, 10:11 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I highlight past dates
Hi Laurie,
Am Thu, 24 May 2012 10:23:40 +0200 schrieb Claus Busch: > select column E => CF => Formula: > =AND(E1>0,E1<TODAY()) I forgot the 4 month. Try: =AND(E1>0,E1<TODAY()-121) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| help with dates in the past | Bradly | Excel Programming | 5 | March 18th 10 01:59 PM |
| record values from past dates | DMC_Chas | Excel Discussion (Misc queries) | 0 | November 18th 06 12:14 AM |
| Past Due - Due Dates | melarmor | Excel Worksheet Functions | 3 | June 2nd 05 06:13 AM |
| Highlight past & future events | rediproof | Excel Discussion (Misc queries) | 4 | May 26th 05 04:01 PM |
| HIGHLIGHT A DATE 10 DAYS BEFORE IT IS PAST DUE | cookie04 | Excel Programming | 1 | January 14th 05 10:04 PM |
Linear Mode
