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
|