Conditional Formatting: 3 range of numbers [Solved/Closed]

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

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?

THANK YOU!

See more 

2 replies

Best answer
MaxStart 346 Posts Tuesday March 3, 2015Registration dateModeratorStatus July 3, 2015 Last seen - May 8, 2015 at 07:40 AM
3
Thank you
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



Result


Good Luck

Thank you, MaxStart 3

Something to say? Add comment

CCM has helped 1767 users this month

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