Previous Topic Next Topic

Conditional Formatting: 3 range of numbers

Solved/Closed
LCC - May 5, 2015 at 09:36 PM
 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!

Related:

1 response

Answer 1 / 1
MaxStart Posts 338 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

Result


Good Luck
LCC
May 10, 2015 at 11:01 PM
Thanks a lot! Tried it and it works! appreciate your time and effort to answer! Cheers!

Similar discussions

Conditional Formatting (more than 3) in Excel
allanabanana -
Waynef -

37 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Conditional Formatting: Font color for entire column based on another column
Kitkatpdx -
Mazzaropi -

5 responses
conditional formatting on multiple criteria
pramvyas000 -
TrowaD -

5 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response