Assign arrow to cell value

[Karen311261]

Hi,

I have to compile a weekly dashboard which has data for the current week and the previous week.

All depending on the change an arrow will be put in the worksheet to show the movement

I would like to be able to run a macro to assign the arrows

Any help would be appreciated

In criteria1 if the value is positive in measures1 and 2 then I need to assign a black arrow down and if the value is negative then the arrow needs to be green up. Measure3 needs to have a up green if it is positive and black down if it is negitive.

In criteria 2 for measures 1 2 and 3 if there is a negative movement then the arrow needs to be green up and black down for positive movement, in measure 4 positive movement is green up and negative black down

Criteria3 all negative movement is green down and positeve black up

Example dashboard attached

Thanks for any help

Karen



I managed to find a solution myself. Not sure it is the most efficient code but it works

I run a series of if statements that display arrows based on the value in a cell

This is my code

Please Login or Register  to view this content.