This is the formula I am using:
=COUNTIF(R16:R44,"Y")/COUNTA(R16:R44)
The conditional formatting I am using works on most cells but a couple
are not working i.e.
[/indent]0 to .7 = red
[/indent].71 to .8 = yellow
[/indent].81 above = green
A couple cells are not formatted - I am thinking it has to do w/the
cell being formatted for % vs. decimal pt. and maybe the decimal is out
by alot.
Any suggestions?...
--
tmerton
------------------------------------------------------------------------
tmerton's Profile:
http://www.excelforum.com/member.php...o&userid=32574
View this thread:
http://www.excelforum.com/showthread...hreadid=523771