Conditional Formatting Formula for Percentage Ranking

You can try this:

Select cells B9:W33, making sure B9 remains the active cell, then apply the following conditional formatting formulas (You can enter them in any order, but before applying them, adjust the order so that <5% is listed first, 5-15% is listed second, 15-25% is listed third, and >25% is listed last):

For <5% use: =AND(B9<>"",B9>17-(17*0.05))
For 5-15% use: =AND(B9<>"",B9>17-(17*0.15))
For 15-25% use: =AND(B9<>"",B9>17-(17*0.25))
For >25% use: =AND(B9<>"",B9<17-(17*0.25))

- Moo