Using formulas in conditional formatting in Apple 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?
After research and trial &amp; 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.