Conditional formatting a percentage

[Wyatt12]

I have a spreadsheet that keeps track of percentages and based on the percentage number at the bottom of the spreadsheet, I would like to have the appropriate box colored in on the sheet. If you open the attachment you'll see what the sheet looks like. I think a formula in conditional formatting will need to be entered.

[JBeaucaire]

Click on cell C10 ad remove the Fill color you placed there.

Then click FORMAT > CONDITIONAL FORMATTING. Set the Condition1 to
Formula Is: =AND(C$14>=$A10,C$14<$A9) then click FORMAT and set your background pattern color.

Now copy that cell up and over.

[JBeaucaire]

Sorry, then click on Cell C1 and use THIS formula for the conditional format since there is no range above it:

=C$14>=$A1

Copy that cell across row 1 only.

NOTE: you could use this formula INSTEAD for the whole chart, and it will result in a "thermometer" effect, so the cells will light up up to the correct cell. Looks cool, too.

[Wyatt12]

Thanks JBeaucaire, it works well. Just one other concern for the cells that have no data why does it highlight those cells also. Is there any additional function that would eliminate this from happening?

Thanks

Wyatt 12:

[JBeaucaire]

Yeah, sorry I didn't notice that, although technically you DID label row ten 0% and blank=0%...but I know what you mean.

Highlight C10 and change the Conditional Format to:

=C$14>$A10

Copy that cell across row 10 only.

==============
If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]