• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 97
  • Last Modified:

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
0
Bright01
Asked:
Bright01
  • 2
1 Solution
 
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.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now