Inserting upward pointing green triangle

Help,

I am working on stock market indices and I need to auto insert green
upward pointing triangles for positive change to indices and red
downward pointing triangles for negative change for the indices on
excel. can anyone help?

thanks!

david

You could format a cell (D2 in this example) with Wingdings font, and
enter a formula similar to the following:

=IF(C2<C1,CHAR(234),IF(C2>C1,CHAR(233),""))

In Wingdings font, 234 is a down arrow, 233 is an up arrow.

Select the cell and format with green font.
Choose Format>Conditional Formatting
From the first dropdown, choose Cell Value Is
In the next dropdown, choose 'equal to'
In the formula box, hold the Alt key and on the
number keypad, type: 0234
Click Format, and choose Red as the font colour
Click OK, click OK

Copy the formula down to the last row of data

David Mok wrote:
> Help,
>
> I am working on stock market indices and I need to auto insert green
> upward pointing triangles for positive change to indices and red
> downward pointing triangles for negative change for the indices on
> excel. can anyone help?
>
> thanks!
>
> david


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

If you want triangles instead of arrows, use Wingding3 font, and
CHAR(113) for a down triangle, and CHAR(112) for an up triangle.

Debra Dalgleish wrote:
> You could format a cell (D2 in this example) with Wingdings font, and
> enter a formula similar to the following:
>
> =IF(C2<C1,CHAR(234),IF(C2>C1,CHAR(233),""))
>
> In Wingdings font, 234 is a down arrow, 233 is an up arrow.
>
> Select the cell and format with green font.
> Choose Format>Conditional Formatting
> From the first dropdown, choose Cell Value Is
> In the next dropdown, choose 'equal to'
> In the formula box, hold the Alt key and on the
> number keypad, type: 0234
> Click Format, and choose Red as the font colour
> Click OK, click OK
>
> Copy the formula down to the last row of data
>
> David Mok wrote:
>
>> Help,
>>
>> I am working on stock market indices and I need to auto insert green
>> upward pointing triangles for positive change to indices and red
>> downward pointing triangles for negative change for the indices on
>> excel. can anyone help?
>>
>> thanks!
>>
>> david
>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi Debra,

For some reason, I am not able to the following. As soon as I press and hold the Alt key, no numbers appear in that field. Any idea why this is happening?

Originally Posted by Debra Dalgleish

In the formula box, hold the Alt key and on the
number keypad, type: 0234
Click Format, and choose Red as the font colour
Click OK, click OK

Thanks.

Oh, I got it. One has to keep the ALT key pressed while punching those numbers and then leave the Alt key, then only those characters appear in the box. Thanks.