Symbol Arrow Conditional Format

[Lensmeister]

Hi all,

Hopefully a clear and easy question.

If the cell value >0 I want a green up arrow / trangle
And
If the cell value <0 I want a red down arrow / triangle
And
If the cell value is 0 then nothing shows (this is optional)

How do I get this to work in conditonal formatting ?


I've tried the Icon sets in Excel but it's doing the opposite to what I need.
I saw a video that used it but I cannot get it working in Excel 365

 

[StuLux]

The closest I could get this to work was by 'tricking' Excel to use the red arrow on any number less than -1E-10 (this may work for you particularly if you are no t working with very small fractions of whoel numbers)

 

[Lensmeister]

Thanks I'll give that a go

Will get back lto you later

 

[Lensmeister]

I did exactly above and it didn't work until I reversed the order of the icons

Thanks