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