Is this possible, like you can in other spreadsheet software to do something like this? (color scales)
Numbers app: conditional highlighting using color scales
numbers
Related Solutions
It would appear that SUMIF() does exactly this
=SUMIF(test-range, “test”, [sum-range])
The OP does not specify how TRUE or FALSE are represented in the cell, but as was stated in another answer, using text is rule will work. This also works for checkboxes, they resolve to TRUE and FALSE as well.
- Text is TRUE add formatting
- Text is FALSE add other formatting
This works for the result of a formula returning the text TRUE or FALSE. If one is using numbers for Booleans, i.e.: 0 or not 0 then use a number rule.
- Number is equal to 0 [zero representing FALSE] add formatting
- Number is not equal to 0 [in the case of any number is TRUE] other formatting
See screenshots for examples.
Best Answer
Try conditional highlighting - this doesn't provide quite that high level of automation, as you have to add rules one-by-one - but you can automate values with all sorts of controls. Find the main menu in Format -> Cell -> Conditional Highlighting...
Here is the main menu:
You have options such as: Numbers | Text | Date | Duration | Blank
Hope this helps :-)