"if" statment in excell cell that will change format in another

[Paul]

[Ron Rosenfeld]

On Tue, 1 Aug 2006 23:45:01 -0700, Paul <[email protected]> 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

[Paul]

Thanks. will give this a go

"Ron Rosenfeld" wrote:

> On Tue, 1 Aug 2006 23:45:01 -0700, Paul <[email protected]> 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
>