View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.newusers
Pete_UK
 
Posts: n/a
Default New to excel - need help with a formula

Kessa,

I've experimented a bit and found the following arrow symbols in
Wingdings (I think it depends on which version of Windows you have, as
a font sheet I did some years ago is different):

UP - CHAR(199), Down - CHAR(200), Same - CHAR(198)

My other comments about conditional formatting still hold, but you will
have to enter the CHAR(199) rather than just "J".

Hope this helps.

Pete