Results 1 to 4 of 4

How to display a coloured an UP Arrow or Down Arrow in a cel

This is a discussion on How to display a coloured an UP Arrow or Down Arrow in a cel within the Excel Questions forums, part of the Question Forums category; I wish to display an up arrow or down arrow symbol in a certain cell in spreadsheet. Is there any ...

  1. #1
    New Member
    Join Date
    Aug 2002
    Posts
    3

    Default

    I wish to display an up arrow or down arrow symbol in a certain cell in spreadsheet. Is there any way to do that ?

    Thanks !!!

  2. #2
    MrExcel MVP
    Join Date
    May 2002
    Posts
    13,946

    Default

    =char(221)
    and
    =char(223)

    for up & down arrows respectively. Format cells to have the symbol font & colour you want.

    Paddy

  3. #3
    Board Regular RichardS's Avatar
    Join Date
    Feb 2002
    Location
    Victoria, Australia
    Posts
    761

    Default

    Have a look at the character map, Start menu, Programs, Accessories, System Tools (at least it is on my system Windows 2000)
    If absence makes the heart grow fonder and familiarity breeds contempt, perhaps my wife should live in Darwin?

  4. #4
    Board Regular
    Join Date
    Aug 2002
    Posts
    145

    Default

    Hi Wongchaa,

    This worked for me :

    If you're trying to put the up/down arrow in cell A1 (based on the value of B1).

    Format A1 with text in Wingdings.

    In cell A2 put the character for up-arrow (you'll find it by Insert Symbol & then looking up the symbol)

    In cell A3 put the character for down-arrow (you'll find it by Insert Symbol & then looking up the symbol)

    Put the formula in cell A1 that tells whether you want to use up or down eg:

    IF(B1>0,$A$2,IF(B1=0,"",$A$3))

    For extra visibility, I also use conditional formatting to display the symbol in green when it is the up arrow, & red when it is the down arrow.



Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com