Forum Discussion

Copper Contributor

Jan 12, 2019

trying to figure out formula

if c3 => 90% of b3 c3 cell fills green. =<89% of b3 c3 cell fills red. How do I do this?

Diamond Contributor

Jan 12, 2019

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)