COUNTIF or something else

[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

 

[Bob Phillips]

If it is conditional formatting, you will need test the same criteria as the
formatting, for instance say the status is <25%, Red, <75%, Amber, else
green, then

=COUNTIF(A2:A1000,"<.25")

If it is filled manually, see
http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Steve Paddock]

Many thanks for the link. It looks to be exactly what I want.

Steve

 

[Bob Phillips]

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)

 

[Steve Paddock]

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.