Color change of cell if value is higher than specified cell to 130%

[kashifjillani]

Hi experts,

Wondering if someone know how to

Highlight a cell if value is >130% from another cell

e.g.

if cell B10 is greater than C10 by 130% (or custom % value)

requred is if value in C10 = 10 and B10 = 13 then B10 should turn green if 15 yellow and if >18 red

regards,

 

[TheCman81]

Use condition formatting using a formula and use

=B10>C10+130%

 

[TheCman81]

Im going to expand on the above. Assuming you mean:

Green for anything >130% but <150%
Amber for anything >=150% but <=180%
Red >180%

Excel 2010

	B	C	D	E	F	G
9			Green	Amber	Red	%
10	13	10	TRUE	FALSE	FALSE	130%
11	12	10	FALSE	FALSE	FALSE	120%
12	19	10	FALSE	FALSE	TRUE	190%
13	12	10	FALSE	FALSE	FALSE	120%
14	18	10	FALSE	TRUE	FALSE	180%

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D10 =AND(B10>=C10*130%,B10<C10*150%) E10 =AND(B10>=C10*150%,B10<=C10*180%) F10 =B10>C10*180% <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[kashifjillani]

Thanks guys,

That did the job for me

Boss is happy to see this presentation

regards,

Im going to expand on the above. Assuming you mean:

Green for anything >130% but <150%
Amber for anything >=150% but <=180%
Red >180%

Excel 2010

	B	C	D	E	F	G
9			Green	Amber	Red	%
10	13	10	TRUE	FALSE	FALSE	130%
11	12	10	FALSE	FALSE	FALSE	120%
12	19	10	FALSE	FALSE	TRUE	190%
13	12	10	FALSE	FALSE	FALSE	120%
14	18	10	FALSE	TRUE	FALSE	180%

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D10 =AND(B10>=C10*130%,B10<c10*150%< font="">)</c10*150%<> E10 =AND(B10>=C10*150%,B10<=C10*180%) F10 =B10>C10*180% <tbody> </tbody>

<tbody>
</tbody>