special formating

[Chad]

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.

 

[Shane Devenshire]

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...

 

[Chris Bode via OfficeKB.com]

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 Format>Conditional 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