trying to figure out formula

Copper Contributor

if c3 => 90% of b3 c3 cell fills green. =<89% of b3 c3 cell fills red.

How do I do this?

excel1.jpg

5 Replies

You may apply two conditional formatting rules with formulas

for green
=($C3>=0.9*$B3)*($B3>0)

for red
=($C3<=0.89*$B3)*($C3>0)

image.png

Hi @BryanGriffy

 

Use conditional formatting. file attach for your reference.

Awesome, how do I see the formula you used?

 

 


@Naveen1992 wrote:

Hi @BryanGriffy

 

Use conditional formatting. file attach for your reference.


 

I found it, Thank you so much for the help.

Hi @BryanGriffy,

 

 

Don't mention it. Just keep learning......

 

Regards,

Naveen