Calculating a Status %

[vkazmierski]

Hello,

I have been refferencing this site for a while and finally had a question that I could not find the answer too, so this is my first post. I am not sure if it is possible or not, but I have havent been able to find exactly what I am looking for. I took over a spreadsheet that is tracking status of varrious projects and the cells are set to change to certin colors based on %. What I am looking to do is essentially the same thing, however I want my percentage that it changing against to be variable based on the date.

Ex. we have 30 days to complete step one (1/30 complete), 20 days to complete step 2 (2/20 complete), 10 days to complete step 3 (3/1 complete). If it is 2/25 and step one is finished and 100% I would like it green, if step 2 is not yet finished say 60% and after the due date I would like it red, and if step 3 is 50% but halfway to finish and is on traget I would like it to show yellow.

I hope I did not confuse things to much. Is this possible, and if so how?

Thank you for the support,

-V

[mahju]

Hi

Welcome to the form

Please upload a sample file to demonstrate your layout input and output you want

To attache a sheet click go advanced click the paper pin icon and follw the screen

Regards