i have a row with a set of percentage values that have to be formatted as
percentages. How do i compare these to boundary figures in an if loop ie. If
.....value 50% then

I have got it working if they are not formatted as % but changing it causes
it not to work. The only way round it i can think of is to create a copy of
the row to be displayed and not fomat that row as %'s, then compare against
that row. That sounds a bit messy though.

Tom

if ActiveCell.Value .5 then

--
Regards,
Tom Ogilvy


"tom1646" wrote in message
...
i have a row with a set of percentage values that have to be formatted as
percentages. How do i compare these to boundary figures in an if loop ie.
If
....value 50% then

I have got it working if they are not formatted as % but changing it
causes
it not to work. The only way round it i can think of is to create a copy
of
the row to be displayed and not fomat that row as %'s, then compare
against
that row. That sounds a bit messy though.

Tom