Numbers formula to change color?

Please have a look at this, you can use Conditional Highlighting to change the color / text style based on the value of a cell.

Use cell conditions in Numbers on Mac - Apple Support

Or search on YouTube for "conditional highlighting numbers"

Here some examples:



Hope this will help

Ralf

The false portion will return 0 as a result, correct?

Yes then you can do it based on the fact that the cell is 0

The 0 is not the false portion of an IF function, it is the error code from an IFERROR function

Here is an example that uses two versions of the formula in column C.

Both are triggered by the TRUE or FALSE value in column A.

Both create the same value in the iftrue part, but diffeent values in the if false part.

The conditional highlighting rule compares the result in column C (the cell to be highlighted) with the value in the same row of column E.

If they are different, the formula sets "red text" as the highlight colour for that row's cell in column C. If they are the same, then both were created by the iftrue part of the formula in its cell, and the rule is not applied.

Column E may be hidden.

Regards,

Barry

You could do something like this.

Work with support cells

Cell B2 contains the formula that you would have in the true section of your IF formula, in this easy example: C2×D2

Cell B3 contains the formula that you would have in the false section of your IF formula, in this easy example: C3+D3

The IF formula in B4 is checking: Is D4 = 0, if yes take the value from B2 and if not take the value from B3

As soon as you add a Conditional Highlighting it will work, as long as B2 and B3 don't have the identical result in the calculation.

I have to agree with Barry the point with X = 0 and X * 5 is confusing.

Ralf

Sunnyintoronto123 wrote:

is it possible to change color of cell or text via formula?

No, you cannot use formulas to change the color of text in a Numbers document.

You can change colors using conditional highlighting or scripting. But more specifics are needed on your document and what you are trying to do.

SG

Can you give an example? There doesn't seem to be an IF statement in your screenshots so it is hard to know what you want.

A formula can determine the value in a cell but not the appearance of a cell. But the appearance of a cell can be set based on the value found in the cell, either through Conditional Highlighting or a script.

SG

"z is interpolation formula "

Do you mean "z represents an interpolation formula that is called if x is not equal to zero" or is the text "z" the result to be returned if x is not equal to zero.

In the formula as written,

IF x is zero, the result will be zero times 5, which is zero.

IF x is any other value, the result will be whatever value is determined by the formula z.

If z will never return a value of 0, you need only one CH rule:

Number is not 0 —> red text

Regards,

Barry

No, formulas themselves cannot change the colors of cells. When do you want the text in a cell to turn red?

SG