So I don't know if I'm in the right group for this type of question. I want
to make a cell give an arrow up symbol when the ref cell is a positive and
arrow down symbol when that same cell is a negative? I already have the
symbol as Wingding3:
Up arrow: Ç
Down arrow: È

Any help in the matter would be great!
Thanks in advance

You can't do it with conditional formatting. Instead, just use a
formula:

=IF(A1<=0,È,Ç)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"EW" wrote in message
...
So I don't know if I'm in the right group for this type of
question. I want
to make a cell give an arrow up symbol when the ref cell is a
positive and
arrow down symbol when that same cell is a negative? I already
have the
symbol as Wingding3:
Up arrow: Ç
Down arrow: È

Any help in the matter would be great!
Thanks in advance

That did the trick, thanks!

"Chip Pearson" wrote:

You can't do it with conditional formatting. Instead, just use a
formula:

=IF(A1<=0,È,Ç)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"EW" wrote in message
...
So I don't know if I'm in the right group for this type of
question. I want
to make a cell give an arrow up symbol when the ref cell is a
positive and
arrow down symbol when that same cell is a negative? I already
have the
symbol as Wingding3:
Up arrow: Ç
Down arrow: È

Any help in the matter would be great!
Thanks in advance

EW wrote:
So I don't know if I'm in the right group for this type of question. I want
to make a cell give an arrow up symbol when the ref cell is a positive and
arrow down symbol when that same cell is a negative? I already have the
symbol as Wingding3:
Up arrow: Ç
Down arrow: È

Any help in the matter would be great!
Thanks in advance

Hi,
Is this what you mean?...

=IF(B1<0,"i",IF(B10,"h","")) in A1 referencing the value in B1 with A1
Font Windings3 you get a thin down arrow when B1 is <0, a thin up arrow
when B1 is 0 and a blankcell when B1 =0

Ken Johnson

As formula you could use =A1 (the cell you want to refer to) and then
set a custom cell format (format-cell-custom) to \Ç;\È;

for an up arrow symbol use Alt 24 †‘ and the down arrow is Alt 25 †“
ie. hold down your Alt key and type 24 on your number key pad (do not use
the numbers above the letters on your keyboard as this will not work)
formula would be =if(cellref0,"†‘","†“")


"lexcel" wrote:

As formula you could use =A1 (the cell you want to refer to) and then
set a custom cell format (format-cell-custom) to \Ç;\È;