project tracking

First post in this forum. I am an Excel novice. I can develop simple formulas. I did my first pivot table last week. The only VBA I've done is stuff I've copied from others and pasted into my own spreadsheet. Some of the questions I have I'm sure can be done, but am unfamiliar with terms...

Using my example below, I used conditional formatting that will fill in columns D - K based upon the data in columns A & B. Now I need to be able to change the color of the fill from the default to "green" when there is a "C" in column C (status). Thanking you in advance - Andrea <tbody>...

<tbody> Start Date Due Date 3/28 3/29 3/30 3/31 4/1 4/2 4/3 4/4 3/28 4/2 3/28 4/1 3/28 4/4 </tbody> I need help with a formula that would consider start date and due by date - then fill in the appropriate dates to the right with a color...

This is my first post, so please forgive if I overlook a requirement. I have the following variables: Budget Costs # of items requiring repair # of items repaired Start date End date QUESTION 1/2: What formula will calculate if all items will be repaired by the end date at the current rate...

Hi there, first time poster. I don't have need for a robust project management/tracking program, so I created a *simple* spreadsheet that lists current tasks, percentage done, etc. I'd like to know if there is a way I can have a (Notes) cell as the last column that allows me to click on the...