Home

trying to figure out formula

Highlighted
New 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
Highlighted

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

Highlighted

Hi @BryanGriffy

 

Use conditional formatting. file attach for your reference.

Highlighted

Awesome, how do I see the formula you used?

 

 


@Naveen1992 wrote:

Hi @BryanGriffy

 

Use conditional formatting. file attach for your reference.


 

Highlighted

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

Highlighted

Hi @BryanGriffy,

 

 

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

 

Regards,

Naveen

Related Conversations
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Leap year formula
Hattsoff in Excel on
4 Replies