So say I have a cell look at another cell that shows profit can i make it
then put a Green arrow point up is that cell is positive and a red arrow
pointing down if the number is negative. like the stock market arrow.

Hi,

You can if you are using Excel 2007:

Take a look under Home tab, Conditional Formatting, Icon Sets.

In 2003 this is not available, you could use the drawing tools and vba, or
just use the drawing tools, manually. Click the Drawing tool on the toolbar
and on the Drawing Toolbar open AutoShape, Block Arrows...

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Chad" wrote:


So say I have a cell look at another cell that shows profit can i make it
then put a Green arrow point up is that cell is positive and a red arrow
pointing down if the number is negative. like the stock market arrow.

I suggest you to use conditional formatting instead to display the cell
background in red color if the values is negative and in green color if it is
positive. You can achieve this as follows
Suppose that your look up data is in column B then
1.Select column B
2.Click FormatConditional Formatting.. from the toolbar
3.In the dialog box, select cell value is from the leftmost drop down list
4.Select Less then from the middle drop down list
5.Enter 0 in the box at the right
6.Click the Format button and choose Red color
7.Click OK
8.Click on the Add button
9.Select cell value is from the leftmost drop down list
10. Select greater then from the middle drop down list
11. Enter 0 in the box at the right
12.Click OK

Now You are done!

Have a nice time€¦..

Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1