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
LVL 1
fb1990Asked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Refer to the attached and look at the red tab.
conditional-formatting.xlsx
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
The values for green should be 0.9 and for yellow should be 0.75 in the conditional formatting and it would work.
0
 
fb1990Author Commented:
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
0
 
fb1990Author Commented:
Thank you very much.  It worked now.  I really appreciate it.  Thanks a bunch.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome. Glad to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.