numbers
I'm using Apple Numbers in macOS, and utilizing its conditional formatting feature to compare some numbers, however I want to compare the numbers' absolute value.
The numbers I work on are estimations, and the sign signifies whether the value is an under or overestimation, but I need its distance from the actual value while comparing the two. I wanted to do it in conditional formatting to not to add more columns to the table. Is it possible in Apple Numbers?
When I click in the formula entry bar I get an additional toolbar that has a "Formula Text Size" field. Does this appear on your screen?
Here's a screenshot from the Numbers '09 User's Guide:
I haven't found a way to make it larger than 14.
I figured out how to make it larger than 14.
defaults write com.apple.iWork.Numbers LSFormulaBarFontSize 80
When you run Numbers again your formula bar is plenty big:
You can use a number smaller than 80 in the Terminal command for a more reasonably-sized formula bar.
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.
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.
Best Answer
After research and trial & error sessions, I understood that using formulation in conditional formatting rules is impossible in Numbers. One can only use simple comparisons for formatting. Preparation of values for comparison is needed to be done on the table.