How can I make row colour change as per value in Numbers?

Example:

1. Formula in D2 =IF(MIN(A2:C2)<3.9,"~","")
2. Fill down to complete the column
3. Select cells A2:C4
4. Start creating a conditional highlighting rule for "text does not end with"
5. In the box where you would enter the text, click on the green oval instead
6. Select cell D2.
7. Change it to $D2
8. Click the arrow to accept it.
9. Finish making the rule to give it the highlighting you want.
10. Hide column D

The basic idea is to have a column with a formula that results in "~" when the row should be highlighted and "" (a null string) when it should not be highlighted then use the "text does not end with" highlighting rule as described in the steps above. You can use a different character than "~" if that character might be found in your data. Pick a character you would never encounter. CHAR can be used to create any unicode character. CHAR(10003) is a checkmark and might be a good choice.

D2 =IF(MIN(A2:C2)<3.9,CHAR(10003),"")

Hi mdeviller,

Because you have two conditions (below 3.9 or above 13.3), the OR function will add functionality to Badunit's formula.

Formula in D2 (and fill down) is IF(OR(MIN(A2:C2)<3.9,MAX(A2:C2)>13.3),"~","")

Then proceed with Badunit's point 4: a conditional highlighting rule for "text does not end with"

Regards,

Ian.