Using formulas in conditional formatting 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.