Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
flagging dates with conditional formatting
I have been struggling with this for quite a while. I am
trying to track overdue dates. Here's the setup. ColA contain a date on which I run the check, eg today's 13/10/2004. ColI contains the date I am trying to track. If the date in ColI is 2 days less than the date of ColA then it's needs to be flagged red, e.g. 11/10/2004 or 05/10/2004. If the date is within the last 2 days (12/10/2004) then it doesn't need flagged. Sometimes there may be blanks so I would need to account for this. Hope this makes sense. I'm ok with conditional formatting but its the formula that gets me. Can someone help. Thanks. Tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
flagging dates with conditional formatting
Hi
try the following: - select I1:I10 - goto the conditional format dialog - enter the following formula =(I1<A1-2)*(I1<"") "Tony" wrote: I have been struggling with this for quite a while. I am trying to track overdue dates. Here's the setup. ColA contain a date on which I run the check, eg today's 13/10/2004. ColI contains the date I am trying to track. If the date in ColI is 2 days less than the date of ColA then it's needs to be flagged red, e.g. 11/10/2004 or 05/10/2004. If the date is within the last 2 days (12/10/2004) then it doesn't need flagged. Sometimes there may be blanks so I would need to account for this. Hope this makes sense. I'm ok with conditional formatting but its the formula that gets me. Can someone help. Thanks. Tony |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
flagging dates with conditional formatting
I think it should only subtract 1, 11/10 needs to be flagged.
-- HTH RP "Frank Kabel" wrote in message ... Hi try the following: - select I1:I10 - goto the conditional format dialog - enter the following formula =(I1<A1-2)*(I1<"") "Tony" wrote: I have been struggling with this for quite a while. I am trying to track overdue dates. Here's the setup. ColA contain a date on which I run the check, eg today's 13/10/2004. ColI contains the date I am trying to track. If the date in ColI is 2 days less than the date of ColA then it's needs to be flagged red, e.g. 11/10/2004 or 05/10/2004. If the date is within the last 2 days (12/10/2004) then it doesn't need flagged. Sometimes there may be blanks so I would need to account for this. Hope this makes sense. I'm ok with conditional formatting but its the formula that gets me. Can someone help. Thanks. Tony |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
flagging dates with conditional formatting
Bob,
agree on that. Tnaks for the correction :-) "Bob Phillips" wrote: I think it should only subtract 1, 11/10 needs to be flagged. -- HTH RP "Frank Kabel" wrote in message ... Hi try the following: - select I1:I10 - goto the conditional format dialog - enter the following formula =(I1<A1-2)*(I1<"") "Tony" wrote: I have been struggling with this for quite a while. I am trying to track overdue dates. Here's the setup. ColA contain a date on which I run the check, eg today's 13/10/2004. ColI contains the date I am trying to track. If the date in ColI is 2 days less than the date of ColA then it's needs to be flagged red, e.g. 11/10/2004 or 05/10/2004. If the date is within the last 2 days (12/10/2004) then it doesn't need flagged. Sometimes there may be blanks so I would need to account for this. Hope this makes sense. I'm ok with conditional formatting but its the formula that gets me. Can someone help. Thanks. Tony |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
flagging dates with conditional formatting
Frank & Bob,
Perfect. Thanks for both your help Tony -----Original Message----- I think it should only subtract 1, 11/10 needs to be flagged. -- HTH RP "Frank Kabel" wrote in message ... Hi try the following: - select I1:I10 - goto the conditional format dialog - enter the following formula =(I1<A1-2)*(I1<"") "Tony" wrote: I have been struggling with this for quite a while. I am trying to track overdue dates. Here's the setup. ColA contain a date on which I run the check, eg today's 13/10/2004. ColI contains the date I am trying to track. If the date in ColI is 2 days less than the date of ColA then it's needs to be flagged red, e.g. 11/10/2004 or 05/10/2004. If the date is within the last 2 days (12/10/2004) then it doesn't need flagged. Sometimes there may be blanks so I would need to account for this. Hope this makes sense. I'm ok with conditional formatting but its the formula that gets me. Can someone help. Thanks. Tony . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flagging dates with conditional formatting | Excel Worksheet Functions | |||
Conditional Formatting Dates | Excel Discussion (Misc queries) | |||
conditional formatting using dates | Excel Discussion (Misc queries) | |||
Conditional Formatting & Dates? | Excel Discussion (Misc queries) | |||
macro needed for flagging dates due | Excel Programming |