How do you automate arrows in Excel?
I am trying to have a cell show a green upward facing arrow for positive numbers and a red negative downward facing for negative numbers. I tried to use conditional formatting for this, but first of all, I do not know how to have this refer to an adjacent cell to do the conditional formatting. Also, for conditional formatting, I only know how to change the color of the cell or characters using this method. I then try using an if statement, but it also does not work.
I use letters because I am using the Marlett font.
=IF(I13>o, t, u)
Any help would be greatly appreciated. Thanks.
Bookmarks