Conditional format formula to format cell colour based on a percentage of the cell

[max8719]

H Excellers,

I have a formula based total in I3

In E3 I have a formula based total too.

I need to conditional format the I3. Red if greater than or equal to 25% of E3, Amber 10% to 24% of E3, Green if 0% to 9%.

I do not have the space to create a separate percentage column.

Thank you in advance.

 

[James006]

Hello,

You will need three rules ... one for each color ...

To get you started here is the formula for Red :

=I3>=E3*0.25

Hope this will help

 

[max8719]

Thanks, that works

 

[James006]

You are Welcome ...