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!


--
rmcgal
------------------------------------------------------------------------
rmcgal's Profile: http://www.excelforum.com/member.php...o&userid=26349
View this thread: http://www.excelforum.com/showthread...hreadid=396578