Conditional Formatting is not working...

T

tmerton

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 coupl
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/th
cell being formatted for % vs. decimal pt. and maybe the decimal is ou
by alot.

Any suggestions?..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting with Icon Sets 0
Conditional formatting 9
Conditional Formatting Formula Not Working 1
Excel 2007 - Conditional Formatting Problem with Percentages 3
Conditional Formatting 7
conditional formatting 1
Conditional Formatting with COUNTIF 2
Conditional Formatting from a group 6

Top