Here is an update for you, however, this code is not correct. You can see you set your green, red, and yellow ranges. However, toward the end you say if AH33 = RangeColor. A range can't be equal to another range. That is like saying if New York = Chicago. You need to look at a specific aspect of the range, usually the value. So you can say:
However, that won't quite work as RangeGreen is a number of cells, and thus has multiple values. So you're going to need to decide what you are comparing AH33 to, and continue from there. My guess is you'll need to define the greatest and least values in each colored zone, then check the Input to see which zone it lies in. Good Luck, and feel free to ask any questions that come up.
Bookmarks