project database

Hi, I'm trying to make an overview of all projects that have been started and in what status they are in. To make a management summary I want to log how long (days) the status "open" or the status "Hold" is activated for the project. But when the X shift between the columns the last status is...

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>...

I am trying to track project activities and establish history for a sales and manufacturing process. We are a dealer and everything we do is pretty much custom-built. We do not maintain inventory. This database will not be used to monitor inventory levels, issue purchase orders, or generate...