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.

"PMLACC" wrote:

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.