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
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
Last Comment
Tracy
ASKER CERTIFIED SOLUTION
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.
ASKER
An immense help! Thank you!
Happy to help :-)