Hi, I have a spreadsheet that I am trying to format, if possible, with conditional formatting.
Basically I need the following 3 things:
- any tasks that are overdue to have the date flag up as overdue (red)
- any tasks that are complete but not on schedule to be flagged as (yellow)
- any tasks that were completed on schedule to be just plain text
I have attached a sample of what I am after. If it is possible that anyone could help me out, that would be great.
Cheers,
Hi
(Assuming target dates are in Column A and Completion dates in Column B)
Goto Conditional Formatting > Use a formula to determine which cells to format-
For "RED" formatting, use formula-
=AND(A1>=TODAY(),B1="")
For "YELLOW" formatting use formula-
=AND(A1<B1,B1<>"")
Check attached for example.
Table Example.xlsx
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
That almost works,
The only thing that does not seem to work is if the date in A2 is say the 7/05/16 it should not flag up red until it has reached that date. Correct?
However this doe snot seem to be happening.
Cheers.
oops, my bad.
I reversed the sign.
For "RED" formatting, use formula-
=AND(A1<=TODAY(),B1="")
Haha,
I should really have just noticed that myself instead of being ignorant of it.
I appreciate your help a lot, it has saved me a headache at work today!
Cheers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks