special formating

  • Thread starter Thread starter Chad
  • Start date Start date
C

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I format a cell using symbols within a formula? 3
ICON Arrows UP or DOWN 7
Conditional Format Objects? 3
Moving comment box leader arrow head 0
Conditional formatting problem in Excel 12 / 2007 5
Conditional Formatting Query 1
Conditional formatting - Numbers and words 1
Resetting cell format from TEXT to NUMERIC and DATE 2

Back
Top