I would like to enter a date into a cell, then in 5 days after that date the cell fill turns yellow, ten days red. Any help?
I would like to enter a date into a cell, then in 5 days after that date the cell fill turns yellow, ten days red. Any help?
Welcome,
Try Conditional Formatting.
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
I thought that was the answer. But I don't know what the dates will be between to make this work. I have ten people entering a date that they start a project (the dates all vary) but one thing remains true 5 days from the date they enter the project that cell needs to highlight to a yellow and 10 days from the date they enter it needs to turn red. (not that this needs to be clarified but I am a rookie excel user)
Right now everyone is filling the cell on their own to demonstrate 5 days past 10 days past. This is dangerous because people will lie about the first date they put in so that nothing is ever highlighted red.
thanks!!!
Last edited by Mrs.Z; 03-07-2011 at 12:48 PM.
How about:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks