functions to change color of fonts or cell backgrounds?
 

Is there a way to use a function in a cell to reference another cell and also
make the other cell change colors in background or font. It would be like
using conditional formatting but it would be controlled in a cell. It would
look like this:
=if (A10,A1 background is yellow, leave as is)

Are there cell formula change color functions for background and fonts?

Thank you

functions to change color of fonts or cell backgrounds?
 

Functions used in worksheets can only return a value to the cell in which
they are contained. With some very rare exceptions, they can not alter the
excel environment.

--
Regards,
Tom Ogilvy


"Yogi Smith" wrote:

Is there a way to use a function in a cell to reference another cell and also
make the other cell change colors in background or font. It would be like
using conditional formatting but it would be controlled in a cell. It would
look like this:
=if (A10,A1 background is yellow, leave as is)

Are there cell formula change color functions for background and fonts?

Thank you