close
This is the formula I am using:
=COUNTIF(R16:R44,quot;Yquot;)/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: www.excelforum.com/member.php...oamp;userid=32574
View this thread: www.excelforum.com/showthread...hreadid=523771Please stick with the original newsgroup thread
全站熱搜
留言列表
