https://bugs.documentfoundation.org/show_bug.cgi?id=159167
--- Comment #6 from Rafael Lima <[email protected]> --- Actually Excel offers a way to achieve this: https://techcommunity.microsoft.com/t5/excel/conditional-formatting-row-by-row/m-p/3966290 In Calc the same can be achieved by setting up a Color Scale (Format - Conditional - Color Scale). Then in "Condition" you must choose "Formula is". Then you write "A1<=A2" in the formula and choose the style. Then do the same for the ">" rule. Let me know if this works for you. -- You are receiving this mail because: You are the assignee for the bug.
