Hi,

Select cell E2, and choose Format, Conditional Formatting, from the first
drop down pick Formula is, in the second box enter a formula like =D1=97.75%
or =D1=.9775 ,for example. Then click the Format button, choose the
Patterns tab and pick a color.

I'm not sure I follow your data, but this is the basic idea.
--
Thanks,
Shane Devenshire


"Pat Rice" wrote:

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