Jan 12 2019 05:20 AM
if c3 => 90% of b3 c3 cell fills green. =<89% of b3 c3 cell fills red.
How do I do this?
Jan 12 2019 05:36 AM
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)
Jan 12 2019 05:45 AM
Jan 12 2019 06:02 AM
Awesome, how do I see the formula you used?
@Naveen1992 wrote:Hi @BryanGriffy
Use conditional formatting. file attach for your reference.
Jan 13 2019 08:50 PM