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?