I have one cell that will change percentage based on calculations from two
other cells. I also have a row with ranges that I need to change color is the
first cell is in that range is meet.

if D1 = 97.75% then I want E2 to highlight. Any Ideas?
D1 E1 - E6
100% 100 %
99.99% to 97.50% 97.49% to 95.00%
94.99% to 92.50% 92.49% to 90.00% 89.99% to
87.50% 87.49% to 85.00% 84.99% to 82.50% 3.00% $25.50 $25.50
82.49% or Less 2.00% $17.00 $17.00

--
We all need a little help