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 (A1>0,A1 background is yellow, leave as is)

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

Thank you