Forum Discussion
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?
5 Replies
I found it, Thank you so much for the help.
Awesome, how do I see the formula you used?
Naveen1992 wrote:Hi BryanGriffy
Use conditional formatting. file attach for your reference.
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)
