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
.
|