Conditional Formatting.

[Pat Rice]

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

 

[ShaneDevenshire]

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.

 

[Pat Rice]

Hi, it not working that way, let me explain a little better.

This is showing possible commision based on percentage of sales so D1 is a
formula result.

D1 could be any where from 100 to 0 and my ranges are
E1 -100%
E2 - 99.99% to 97.50%
E3 - 97.49% to 95.00%
E4 - 94.49% to 92.50%
E5 - 92.49% to 90.00%
E6 - 89.99% to 87.50%
and so on until we get down to 80% or Less.

If the formula works out to show D1 in E3 Range I want E3 to highlight. Is
this more informative?

 

[Roger Govier]

Hi Pat

One way
If you put your higher set of values in E1:E6 and the Lower set in F2:F6
(without any of the text), then use a CF formula of
=AND($D$1<=E1,$D$1>=F1)

 

[Roger Govier]

Sorry, forgot to add that you will need to enter a value in F1
99.991%

 

[Pat Rice]

Thanks that finally did it.