Conditional Formatting: 3 range of numbers

LCC - May 5, 2015 at 09:36 PM
 LCC - May 10, 2015 at 11:01 PM

would like to seek advice from some of the experts here.

I want to do conditional formatting from column O6-O21.

If percentage is above 100%, cell will be green filled with black font

If percentage between 80-100%, cell will be yellow filled with black font

If percentage is below 80%, cell will be red filled with black font

anyone can help?



1 response

MaxStart Posts 340 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
May 8, 2015 at 07:40 AM
Hi there ..
  • Select your range
  • Right Click and set format as percentage

  • Go to: Conditional Formatting -> Manage Rules:

  • 1- New Rule

  • 2- Choose: Format only cells that contain:

  • for the first rule choose: Grater than, enter the value and choose the formatting you need:

  • for the second rule repeat the steps 1 + 2 then choose: Value Between:

  • Create the Last Rule and hit OK


Good Luck
Thanks a lot! Tried it and it works! appreciate your time and effort to answer! Cheers!