When pulling values through from a table array, is there any way that
the formatting can be pulled through too, not just the value? (Office
2003)
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

No, a formula can only return a value.

If the format applied to the table was conditionally formatted, then
you could apply the same conditions to the cell with the formula.

Hope this helps.

Pete

On Feb 13, 8:34*am, Paul Hyett <vidcap...@invalid83261.co.uk> wrote:
> When pulling values through from a table array, is there any way that
> the formatting can be pulled through too, not just the value? (Office
> 2003)
> --
> Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

On Fri, 13 Feb 2009 at 01:26:13, Pete_UK <(E-Mail Removed)> wrote in
microsoft.public.excel :

>No, a formula can only return a value.
>
>If the format applied to the table was conditionally formatted, then
>you could apply the same conditions to the cell with the formula.
>
>Hope this helps.

It's worth looking into at least - thanks.
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)