Conditional formatting rules applies to cells in order from first to last rule. But there are no way to change order of already created rules.
And problem is more significant: when I adding new rule - it inserts not always on last position, sometimes it shows in middle of old rules.
So via deleting and adding new rules I can't solve the problem with right apply order.
Example of problem: If first rule "greater than 5" apply Style "Red color", and second rule "greater than 10" on same cell apply Style "Green color" - all cells less than 10 and less than 5 will have Green color. This can be solved via change rule order, but there are no good way to change it.
Please add interface for change order of Conditional Formatting rules in LibreOffice Calc.
*** This bug has been marked as a duplicate of bug 74074 ***