This is very helpful. Thank you very much.

"Tom Hutchins" wrote:

You can use conditional formatting in A1 (in your example) to do what you
described, without involving any other cells.

There are no built-in Excel functions for working with the colors of cells
or fonts. It is possible to write VBA functions to do this. Chip Pearson has
info on his site:
http://www.cpearson.com/excel/colors.htm

But it looks like conditional formatting is all you need, unless there are
additional factors not yet revealed.

Hope this helps,

Hutch

"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