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?...
Bookmarks