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
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
SSISMicrosoft Excel
Last Comment
Subodh Tiwari (Neeraj)
The values for green should be 0.9 and for yellow should be 0.75 in the conditional formatting and it would work.
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
Thanks for the assistance and the help you provided me 2 days ago
conditional-formatting.xlsx
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you very much. It worked now. I really appreciate it. Thanks a bunch.
You're welcome. Glad to help.