Icon Arrows

[Puggwash63]

Hell o,

As the Conditional format shows icons for arrows, but the Red points down and the Green points up, is there a code that can change the arrows, so that the Red points up and the Green points down?

i have searched and am not able to find anything suitable

Many thanks

Pugg

 

[Fluff]

There's no way changing the existing icons that I know of, but you can create your own.
Have a look here https://contexturesblog.com/archives/2013/09/03/create-your-own-excel-icon-set/

 

[Puggwash63]

I have just about sorted the arrow icons formula out but one of them does not seem to be working.

I'm using the following code:
=IF(E6="","",IF(E6>=Email!I6,$A$17,IF(E6>=Email!I6,$A$18,$A$19)))
E6 will show as £865.94
I6 shows as £865.94
This should mean the Arrow should turn Yellow and point to the right.
It points upwards but shows as yellow.

A17 shows arrow pointing upwards (Windings 3)
A18 shows arrow pointing Right (Windings 3)
A19 shows arrow pointing downwards (Windings 3)

Any ideas?

Many thanks

Pugg

 

[Fluff]

Something looks wrong with your formula, as you have 2 conditions like
E6>=Email!I6

 

[Puggwash63]

I have checked and think the Right angle arrow that should turn Yellow is Pointing upwards and not pointing Right.
This is what i have so far:

[TABLE="width: 622"]
<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]Manufacturing Island[/TD]
[TD]No of Lines[/TD]
[TD]Volume[/TD]
[TD]Value[/TD]
[TD]%[/TD]
[TD]Movement from Last Week[/TD]
[TD]Movement from Last Week[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]1,024[/TD]
[TD]£1,536.00[/TD]
[TD="align: right"]0%[/TD]
[TD]ã[/TD]
[TD="align: right"]£768[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]18[/TD]
[TD]1,831[/TD]
[TD]£2,951.79[/TD]
[TD="align: right"]4%[/TD]
[TD]ã[/TD]
[TD="align: right"]£1,847[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]15[/TD]
[TD]29,283[/TD]
[TD]£53,417.47[/TD]
[TD="align: right"]64%[/TD]
[TD]ä[/TD]
[TD="align: right"]£81,676[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]106[/TD]
[TD]26,342[/TD]
[TD]£24,320.26[/TD]
[TD="align: right"]29%[/TD]
[TD]ä[/TD]
[TD="align: right"]£42,472[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]1[/TD]
[TD]1,471[/TD]
[TD]£865.94[/TD]
[TD="align: right"]1%[/TD]
[TD]ã[/TD]
[TD="align: right"]£0[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD="align: right"]141[/TD]
[TD="align: right"]59,951[/TD]
[TD="align: right"]£83,091[/TD]
[TD="align: right"]98%[/TD]
[TD] [/TD]
[TD="align: right"]-£74,090[/TD]
[/TR]
</tbody>[/TABLE]

F2 formula shows:
=IF(D2="","",IF(D2>=G2,$A$17,IF(D2>=G2,$A$18,$A$19)))


I have cells A17, A18, A19 set as Wingding 3
Where A17 shows as Arrow pointing upwards (Red colour font), A18 should show as Arrow pointing Right (Yellow colour font) and A19 shows Arrow as pointing down (Green colour font).

'F' column has the Arrows and the below is the Conditional Format to colour the Arrows
=AND($G2=$J$6) THIS SHOWS YELLOW FONT
=D2>$J2 THIS SHOWS RED FONT
=D2<$J2 THIS SHOWS GREEN FONT

Would you let me know why the Arrow pointing Right that should show as Yellow (if the cells D and G are equal) the Arrow still points upwards.

Hope this helps

Many thanks

Pugg

 

[Fluff]

Your formula still looks wrong as you have the same criteria twice
=IF(D2="","",IF(D2>=G2,$A$17,IF(D2>=G2,$A$18,$A$19)))

 

[Puggwash63]

how can I get the Yellow Arrow to point right.

Is there a way so you can see the program set up for the file as there are several tabs but only one that has the details I have sent above.

Pugg

 

[Fluff]

You will need to change your formula as you have the same condition twice

 

[Puggwash63]

which one do you think needs changing?

Pugg

 

[Fluff]

As I've never used that type of Cf, I don't know.
Try changing the second one & see what happens.