Is there anyway to write a different formula for the 4 different arrow icon sets so that they put an arrow up or down based on a different formula each value box?
I am trying to say
Highlight up arrow if cell I28-cell I24>=5
Highlight up/side arrow if cell I28-cell I24>=0, <5
Highlight down/side arrow if cell I28-cell I24<0, >-5
Highlight down arrow if cell I28-cell I24<=-5
I am trying to say
Highlight up arrow if cell I28-cell I24>=5
Highlight up/side arrow if cell I28-cell I24>=0, <5
Highlight down/side arrow if cell I28-cell I24<0, >-5
Highlight down arrow if cell I28-cell I24<=-5