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.