Displaying green arrow/yellow dash/red arrow icon set

[GoldBytes]

Excel conditional formatting question. How does one use the green up arrow/yellow dash/red down arrow icon set?

In a column like to display the green arrow if the number prior is smaller, the dash if the number is the same or the red arrow if the number prior is larger.

Thanks all.

 

[DRSteele]

Hi. Welcome to the forum!

Rather than write a long explanation, I'd just rather point you to a video on youtube that will clear it all up for you. Watch this and then come back with any follow-up questions you may have. https://www.youtube.com/watch?v=GRfe4bHsjhI

 

[GoldBytes]

Hi @DRSteele, thanks for the reply. I went through the video's section on icon sets. I'm on v15 of Excel on Mac, dialog for conditional formatting seems to be different. I'm unable to figure out what the two different formulas would be in the new dialog for icon sets to place either the up arrow, dash or down arrow, based on the number in the previous cell.

 

[DRSteele]

Sorry, but I'm unable to help with apple products.