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