Conditional Formatting: 3 range of numbers
Solved/Closed
Related:
- Conditional formatting 3 color scale percentages
- Excel conditional formatting 3-color scale percentage - Best answers
- Excel conditional formatting based on percentage range - Best answers
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Hitman 3 free download - Download - Action and adventure
- Granny 3 download pc - Download - Horror
- Fnia 3 - Download - Adult games
1 response
MaxStart
Posts
338
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
May 8, 2015 at 07:40 AM
May 8, 2015 at 07:40 AM
Hi there ..











Good Luck
- 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
May 10, 2015 at 11:01 PM