Can someone help me figure out how I can create a conditional format from two different dates?
EX:
Start Date 11/10/14
Goal Date - Yellow if within 7 days of Start Date // Red if past due (8+ days)
Actual Date - Red if Goal Date not met by the Start Date deadline of 7 days
This example may assist you.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
I am looking at the Cond Format Example from above and I don't see any formulas? I think I am looking for the same thing as Den789. I am trying to create a certification tracker.
-Certification expires after 1 year
Example
Class taken on 1/1/14 expires on 1/1/15.
I would like the class date to be highlighted GREEN until 90 days from expiration at which point it would turn YELLOW and at 30 days before expiration it would turn RED.
I appreciate the help.
Welcome.
Pls start your own thread as per forum rules which you have to read before you post.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks