Conditional formatting a percentage

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.