How can I make row colour change as per value in Numbers?
If value one cell on my spreadsheet is below 3.9 or above 13.3 how do I change the row to red?
[Re-Titled by Moderator]
iPad Pro, iPadOS 17
Example:
- Formula in D2 =IF(MIN(A2:C2)<3.9,"~","")
- Fill down to complete the column
- Select cells A2:C4
- Start creating a conditional highlighting rule for "text does not end with"
- In the box where you would enter the text, click on the green oval instead
- Select cell D2.
- Change it to $D2
- Click the arrow to accept it.
- Finish making the rule to give it the highlighting you want.
- 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),"")
