The conditions are read in order so if the first condition is
True it is used, If not the second formulas is checked, if that is not
True then the third formulas is checked.

I am not sure of your layout, but since you say it works for most cases
will assume you selected the cells you want colored and that is probably
only once cell.

Condition 1:
=COUNTIF(R16:R44,"Y")/COUNTA(R16:R44) <= .7
Condition 2
=COUNTIF(R16:R44,"Y")/COUNTA(R16:R44) <= .8
Condition 3:
=COUNTIF(R16:R44,"Y")/COUNTA(R16:R44) <= 1

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"tmerton" wrote in message
...

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=523732