Heatmap Graphic Enhanced

EE Pro. Phillip Burton helped me build out a Cycle Heatmap using a macro.  Now I'm trying to intergrate it into a larger Heatmap.  Part of the Map is based on Conditional Formatting (the non-cycle part). The Part Phillip helped me with is based on a Macro in the Sheet (starting at S32-S38) and monitors the score (1-3) to indicate the colors.

Here's what I need;

1.) How do I make the arrows solid instead of transparent?
2.) How do I get rid of error?

Thank you in advance,

B.
D--Data-Data-Temp-Cycle-Heatmap-Extended
Bright01Asked:
Who is Participating?
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Problem 1 - Right-hand click on the arrow, Format Shape, go to Fill and change the Transparency to 0%.

Problem 2 - Change

"Arrow" & (Target.Row) - 1

to

"Arrow" & (Target.Row) - 31
0
 
Bright01Author Commented:
Great!  Works perfectly.  Appreciate the elegant solution and rapid response!

All the best,

B.
0
 
Bright01Author Commented:
Authored another question to get to the next level on this.  Hope you can take a look.

B.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.