make cell color change if requirements are met?

P

PMLACC

Is there a way to make a formula that will change the format of a cell if it
meets certain requirements? I.E. Colors, formulas, etc.
 
J

JLatham

Look at Format | Conditional Formatting
You can change the fill color, font color and other font characteristics
based on the calculated value in the cell. There are also ways to get it to
change those based on (hard for me to explain) that cell meeting criteria
defined by another formula.

But you can't change the formula in a cell based on the results of a formula
in that same cell.
 
P

PMPLookingForToBe

As I know, there is no formula to change the cell properties (maybe text() to
change value format, but no cell format); there is one to obtain that:
cell().

However, you can change the format of a cell using "Conditional format"
(Tools/Conditional format) where you can define up to three diferent formats
for the same cell based on the value of the cell vía core value or a formula.

I suggest you to examine that functionality.

I hope this helps.

Regards.
 
Top