Conditional Formatting formula

[RodneyC]

I need a formula to put in Conditional Formatting for column H that will fill the cell a color based on the condition that the value in the cell is 5% or less. A second formula is needed that will fill the cell with another color if the value is between 5.01% and 10%.

Thanks in advance

 

[Fluff]

How about

=AND(H2<=5%,H2<>"")

and

=AND(H2<=10%,H2<>"")