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

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

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

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

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