Hello everyone:
I was wondering if someone could help me figure this out.
Column B: Date submitted
Column C: Due date
Based on these dates I need the due date cell to change its color once 4 business days from the date it was submitted has elapsed.
Thank you.
I forgot to add (it would not let me edit) that I have the formula =WORKDAY(B3,4) for each cell but I do not know how to make it so it changes color when the due date arrives. Thank you once again!
Hi
If i understoond well your point, then:
Column B: Date submitted>>>example>>>03/01/2012
Column C: Due date>>>>> =WORKDAY(B3,4)
So the Conditional Formatting in C3, is this:>>>Formula is>>> =Today()
In other cells>>>Formula is>>> =C3=TODAY().
hOPE TO HELPS YOU.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
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.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Originally Posted by Fotis1991
Oh wow thank you, let me make sure I got this right
I selected cell C3, click the option conditional formating>new rule>use formula to determine which cells to format:
=Today()
I then selected C4, click the option conditional formating>new rule>use formula to determine which cells to format:
=C3=TODAY()
Thank you!!!!
I must be doing something wrong because when I applied the formula you gave me, the 1/11/2012 dates is highlighted but the 11th isn't until 2 days from nowOh wow thank you, let me make sure I got this right
I selected cell C3, click the option conditional formating>new rule>use formula to determine which cells to format:
=Today()
I then selected C4, click the option conditional formating>new rule>use formula to determine which cells to format:
=C3=TODAY()
Thank you!!!!
Date Submitted Date past due
1/5/2012 1/11/2012
1/5/2012 1/11/2012
1/5/2012 1/11/2012
1/5/2012 1/11/2012
Thank you once again
Yes! This is it!
Glad to helped you.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
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.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Yes you are right... Apologise for it!
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
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.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
I thought I was going insane, so do you happen to know how I can make the due date to highlight in red ONLY when that due date arrives? I have no clue how to!
Thanks again!
Isn't it oK for you??
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
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.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
It did work, sorry I had the previous one opened instead!! I clicked on your star icon
I was wondering if you wouldn't mind another question? I want to use the submit date, due date formula I use earlier however in this particular sheet I do not know the submit date, therefore the =WORKDAY(B3,4) formula gives out an error. What formula can I use on the submit date so that I can use the formula?
I thought of doing TODAY or now but that didn't work!
Also how can I make it so the due date column is blank so when a date is entered on the submit date it automatically adds the 4 business days? right now it does a weird format 01/10/1990, I tried the F5, Constants remove all but number but it didn't work, what's weird is that this worked on the sheet you helped me with the conditional formatting, I hope this makes sense!!! Sorry for being a pain.
doesn't have any data in it but just the formula? I tried F5 then
Hi
1) If you really, clicked in my *star reb.., then there is a problem there....because i received nothing from you(And now that I think it, is really strange. Yesterday it told me, thanks several people for the right solutions that I gave them, but I did not see a single Reb * star, in my folder ..
Is there a problem in the Forum Sofrware, or no one wanted to do this????????)
2) If i understoond well your new point, then in C3, you can use this formula:
=IF(B3="";"";WORKDAY(B3;4))
Hope to helps you.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
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.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks