Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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(C2C1,CHAR(233),"")) In Wingdings font, 234 is a down arrow, 233 is an up arrow. Select the cell and format with green font. Choose FormatConditional 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 |
#3
|
|||
|
|||
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(C2C1,CHAR(233),"")) In Wingdings font, 234 is a down arrow, 233 is an up arrow. Select the cell and format with green font. Choose FormatConditional 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing green triangle in cell | Excel Worksheet Functions | |||
What does a small green triangle in the upper left hand corner of. | Excel Discussion (Misc queries) | |||
I am getting Green triangle on one column in all the cells ? | New Users to Excel |