COUNTIF or something else

  • Thread starter Thread starter Steve Paddock
  • Start date Start date
S

Steve Paddock

I have a SS that is used to track progress of software through a testing
lifecycle. The cell fill formatting is used to indicate where a particular
piece of code is at a given point in time. RED is nowhere near, AMBER is
late & GREEN is achieved. All cells are formatted to accept dates. The dates
entered are the "planned dates"

How can I count the number of green cells in a particular row and then
calculate the percentage of lifecycle achieved. There are 6 steps for each
piece of code.

Many thanks for any help - this could save an awful lot of manual
intervention,

Steve
 
Steve,

Note the constraints in that article regarding not automatically
re-calculating on a colour change.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Yes - Thanks again, just applied the bits and pieces and it works a treat.
Even with the constraints, re-calculating is so much better than manual
input.
 
Back
Top