Thanks. will give this a go

"Ron Rosenfeld" wrote:

On Tue, 1 Aug 2006 23:45:01 -0700, Paul wrote:

Not possible.

Worksheet functions can only return values and only to the cell in which they
are located.

You could change some of the format options in one cell based on the contents
of another cell by using Conditional Formatting in the "target" cell.

Post back with more information if this hint doesn't point you in the correct
direction.




--ron