Bright01
asked on
Heatmap Graphic Enhanced and Extended
I have a great little heatmap that Phillip Burton has helped me build. I have one issue. The Opal Shape is not properly responding to the sum data in S44 to reflect a color based on a average sum, numeric value with two decimal points. It should be an easy fix for someone with Macro skills. I simply need the ability for the right color to show up based on;
0-1.1 = Red
1.1-2=Yellow
2.1-3=Green
That's it!
B.
D--Data-Data-Temp-Cycle-Heatmap-Extended
0-1.1 = Red
1.1-2=Yellow
2.1-3=Green
That's it!
B.
D--Data-Data-Temp-Cycle-Heatmap-Extended
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ejgil,
The code works!
Phillip,
Can you modify the example? I tried the change but couldn't get it to work.
Thanks guys,
B.
The code works!
Phillip,
Can you modify the example? I tried the change but couldn't get it to work.
Thanks guys,
B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great job guys. Both approaches worked and I learned a few new things....thank you for that. In the end, I went with Phillip's solution because it is simple.... but both were equally effective.
Thanks again,
B.
Thanks again,
B.
change CASE 2 to CASE 1.1 TO 2
Change CASE 3 to CASE 2 TO 3