More Conditional Formatting Woes

[rmcgal]

I need help with this...please!

Easiest way to explain this is...

I have three columns...one is a project name...two is the start date of the project...three is a column which will show whether the work is being done IH (in-house), CO (contracted out) or a completion date. That third column will only have one of the three entries at a given time.

I need the 2nd column to automaticallly fill in the current days date ONLY when a project name has ben entered into the 1st column.

I also need the third colum to become yellow when either IH or CO is entered into that cell. While either of these text entries are within the cell, I need the color to change to red, when it become 45 days or more from the Start Date (column 2).

Then when a project becomes complete and I enter a date into that 3rd column, I need the color to change to green.

I currently have one conditional formula correctly entered that controls that turns the cell green upon completion date. However, I cannot get any other formulas to correctly to all of these things together.

Thanks in advance for any help!!

I feel like I am in a boat with only one paddle...just keep circling, but not oing anywhere!