Conditional Formating ?

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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 w=
ant
> 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: =C7
> Down arrow: =C8
>
> Any help in the matter would be great!
> Thanks in advance

Hi,
Is this what you mean?...

=3DIF(B1<0,"i",IF(B1>0,"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 =3D0

Ken Johnson

As formula you could use =3DA1 (the cell you want to refer to) and then
set a custom cell format (format->cell->custom) to \=C7;\=C8;