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

"Champs33" wrote in message
...
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).

Thanks Rob,

Data Bars was what I was looking for !

"RobN" wrote:

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

"Champs33" wrote in message
...
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).