functions to change color of fonts or cell backgrounds?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Hyperlinks Without Changing background shading 14
Tabname function 1
count cells with diagonal borders 3
GridLines Inadvertantly Goes Away with Macro 3
Cell Background Color Change --> Change Event 5
interior colored cells counting 3
Background color change, by using the formula. 1
custom color for font color and or background shading color 2

Back
Top