Hi all,
I have a project sheet in which I record start and end dates for projects. I would like to set up conditional formatting for the end date column so that the cell becomes red if the end date is today and yellow if it is within 3 working days. I'm having some trouble with this, especially the WORKDAY feature. Can anyone please help! Thanks!
you maybe able to use networkdays using startdate today() and your enddate <=3
or workday()
Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Check attached...
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
sorry , thought your set-up was a little more complicated
does
=AND(B2>TODAY(),NETWORKDAYS(TODAY(),B2)<=3)
do the job ?
Thanks! I understand why that formula works in yours but doesn't work in mine. I've uploaded my sample to show what's going on.
its because your apply range starts at D1 and the formula is D2
also change the RED to a formula as you had before
=D1=today()
and for yellow change the D2 to D1
OR
change the range to start at D2
Thank you so much! That was so simple, I don't know why I couldn't figure it out. Not the formula though, I never would have gotten there myself. You're the best!
your welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
Added, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks