How do I display an arrow in a cell

  • Thread starter Thread starter Champs33
  • Start date Start date
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).
 
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
 
Back
Top