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