I have a group of people that tell me their project can be complete in 5 days time 10 days time etc. so I asked them to fill in the cell with the start date. I want that cell to highlight red when the 5 days or 10 days etc... have passed. So the excel spreadsheet has to know when it opens the date that I open it in order to reflect past due cells.
Do you want weekends to be ignored? If not then....
Say A2 has the start date and B2 has the project time in days, like this:
Please Login or Register to view this content.
- Select A2
- Format > Conditional Formatting
- Formula is
Please Login or Register to view this content.- Click on the format button, go to the patterns tab and pick the fill you want.
- OK
- OK
If you DO want weekends to be ignored then you can use this formula instead which was adapted from here:
Please Login or Register to view this content.
Last edited by Colin Legg; 03-09-2011 at 12:56 PM.
I have used this formula in conditional formatting for working days and it works perfectly. I would now like to change the same cell back to black when a date is input in an adjoining cell. Can you please help. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks