I've created a dashboard as shown below. The boxes at the top are merged cells and the tables below are pivot tables.
I'd like to have the boxes part done using shapes though as that will give me the flexibility to move them around, change their size, make them all the same size etc without impacting the tables below.
I know how to do most of it except the arrows. How can I get the conditional arrows to show up with conditional coloring just the way conditional formatting works?
What's the easiest (if possible non-VBA) way to achieve that?

I'd like to have the boxes part done using shapes though as that will give me the flexibility to move them around, change their size, make them all the same size etc without impacting the tables below.
I know how to do most of it except the arrows. How can I get the conditional arrows to show up with conditional coloring just the way conditional formatting works?
What's the easiest (if possible non-VBA) way to achieve that?
