Hi Guys, I am trying to incorporate an up/down arrow in our P&L sheets. I.E, if we are in the red the character is downward pointing and red, if we are in the black a green arrow up arrow will show. This is the formula I am using:
=TEXT(J11-K11,".00%")&IF(J11-K11>0,$U$1,$V$1)
The absolute referenced cells(U1 and V1) contain the symbol I am using:
▲▼
The trick is I am trying to save column space so I would like it to all be in one cell. Conditional formatting is out because the numbers themselves are suppose to be in black and only the arrows are colored.
Question is: how can i insert a colored symbol? Perhaps export the symbol to paint and manipulate at will, but then how do i reimport that as a symbol? Any ideas. I greatly appreciate it. Thanks!!
=TEXT(J11-K11,".00%")&IF(J11-K11>0,$U$1,$V$1)
The absolute referenced cells(U1 and V1) contain the symbol I am using:
▲▼
The trick is I am trying to save column space so I would like it to all be in one cell. Conditional formatting is out because the numbers themselves are suppose to be in black and only the arrows are colored.
Question is: how can i insert a colored symbol? Perhaps export the symbol to paint and manipulate at will, but then how do i reimport that as a symbol? Any ideas. I greatly appreciate it. Thanks!!