Conditional Formatting

[USArmyRET_RKSmith]

Aloha,

I have attached a simple excel document and I have figured out how to conditional format one cell but I can't figure out how to conditional format for four different cases. Is there a way to conditional format Black between 0-10, red between 11-33, yellow between 34-79, green between 80-100?

[#2 · Accepted solution]

@USArmyRET_RKSmith 

You can set one color as default, and create three rules. For example, set green as default background color, and create these rules:

See the attached version.

 

[#3]

Hans,

This is awesome. Thank you for taking the time. I will study your input to increase my knowledge of excel. Have a great day!

r/
Reggie