Avatar of John Darby
John Darby
Flag for United States of America asked on

Excel Conditional Formatting - 8 colors, 8 value ranges

I have 8 data ranges which apply to one evaluated cell for which I want to color a single target cell...
0-19 - White
20-39 - Yellow
40-59 - Orange
60-79 - Green
80-119 - Blue
120-159 - Brown
160-179 - Red
180 and greater - Black

Is there a way you might suggest creating the formatting logic? The numbers are hours and the color represent the belt color for which a student is minimally eligible for a belt rank. My idea is to have a single cell in the workbook which displays the color for which the student is minimally eligibled based on training hours logged.

Thank you!
JohnD
Photos / Graphics SoftwareMicrosoft ExcelVB Script

Avatar of undefined
Last Comment
Tracy

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Tracy

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
John Darby

ASKER
An immense help! Thank you!
Tracy

Happy to help :-)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck