Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |