How do I display an arrow in a cell

C

Champs33

How do I display an arrow in a cell that is relative in size to other values.
Eg cell A1 (value 5) has a small arrow in the cell whereas A2 (value 50)
would have a larger arrow. The overall effect is that by looking at a sheet
the observer would be drawn to the larger arrows (values).
 
R

RobN

One way is by using a helper column B and enter this formula, copying down
as required:
="<" & REPT("-",A1)
But you may want to modify to not show anything if the value in column A is
zero, etc.

If you have Vs 2007 then check out data bars under conditional formatting,
which will do something like that for you without any formulas.

Rob
 

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 to display arrows 2
How do I move to other cells in spreadsheet using up down arrow? 2
Displaying arrow in a dropdown list within cell 2
How do i make the arrow keys tab to the next cell? 1
how do I set the arrow keys to move only the highlight not the ta 1
Arrows not moving from cell to cell, when I push arrow columns m 2
How to Display Arrow for Drop Down Lists in Message Body 0
How do I format a cell using symbols within a formula? 3

Top