Programme Progress

Hi Dave

Thanks for your question.

Conditional Formatting:
Using the 'Use a formula to determine which cells to format' feature you could create a formula that would change the colour of cells if they were a certain number of days near/over the project end date.

IMPORTANT: ALL formulas used for conditional formatting MUST return a TRUE or FALSE answer.

e.g.

TODAY() >= Project End Date

if the above statement is TRUE change colour to RED


As regards viewing the progress graphically it would be difficult to answer without knowing the structure of the data being used to create the chart. We would need more details.

Regards


Dennis