flagging dates with conditional formatting

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

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
 
Hi
try the following:
- select I1:I10
- goto the conditional format dialog
- enter the following formula
=(I1<A1-2)*(I1<>"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel due and overdue date colours 2
Need formula dates 7
compare dates with different formats 2
Date subtraction 1
Date format. 1
Cells() produces reversed date format for double digit dates 5
Multiple Conditions - VBA 1
Autofil on variable rows, delete extract and show remaining rows 3

Back
Top