Colored Symbols

filipm123

New Member
Joined
Aug 29, 2007
Messages
41
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!!
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Select your column with these formulas.

Click on Format then Conditional Formatting:
Under Condition 1
Cell Value is equal to =$U$1
Click on Format
On the Font tab, under Color select a green
Click OK

Click on Add
Under Condition 2
Cell Value is equal to =$V$1
Click on Format
On the Font tab, under Color select a red
Click OK
 
Upvote 0
yea that's how its set up right now, and it works, but I am trying to save column space, and I was hoping to actually insert a colored symbol into excel. have you heard of something like that?

but thanks for the tip on cond formatting.
 
Upvote 0
Sorry, I see what you mean, No you can't have different colors of text in a cell with a formula. It would take VBA to do that, but then the formula would be gone. Are you actually using all 256 columns? Why couldn't use one cell for the number and another for the arrows?
 
Upvote 0
no i am not using allllll the columns, and ill just keep it the way it is. I was thinking about doing something clever like figuring out where excel stores the location of these symbols and amending it there, but I suppose thats entirely too much work for something so small..

i was just hoping someone would know a trick for this. Thanks again!
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,016
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top