Link to home
Start Free TrialLog in
Avatar of fb1990
fb1990

asked on

Conditional formatting in Excel

Hello Experts,

I am trying to format cells to show green when percentage is 90 or greater,  yellow between 75-89 and red when percentage less than 74.  I am having problem getting the format in excel.  Can someone please help me.?
conditional-formatting.xlsx
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

The values for green should be 0.9 and for yellow should be 0.75 in the conditional formatting and it would work.
Avatar of fb1990
fb1990

ASKER

Thanks Subodh.  This one is very problematic.  I tried your suggestion still no luck.  

Thanks for the assistance and the help you provided me 2 days ago
conditional-formatting.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of fb1990

ASKER

Thank you very much.  It worked now.  I really appreciate it.  Thanks a bunch.
You're welcome. Glad to help.