Description: In contrast to Excel, Calc offers no way to control the sequence order in which conditional formatting rules for different overlapping cell ranges are applied. To catch up with Excel, I'd like to suggest the following: 1.) No longer list conditional formatting rules in alphabetical order (with respect to the affected cell ranges), but in the order in which they are actually applied. 2.) Allow re-ordering the rules with "Up" and "Down" buttons, like it is already possible with multiple conditions that refer to the same cell range. Steps to Reproduce: In Calc, open the conditional formatting rules list (Format\Conditional\Manage...). Actual Results: There are no "Up" and "Down" buttons to re-order the rules and thereby change the order in which they are applied. Expected Results: I'd like to be able to control the sequence order (like I can do in Excel). Reproducible: Always User Profile Reset: Yes Additional Info: I know that you already can re-order multiple conditions that refer to the same cell range. But you cannot do so with rules that affect different (yet overlapping) cell ranges like Excel can.
Created attachment 196036 [details] Rules for DIFFERENT (overlapping) cell ranges Attachment_1.jpg: Rules for DIFFERENT (overlapping) cell ranges cannot be re-ordered in order to control the order in which they are applied.
*** This bug has been marked as a duplicate of bug 126047 ***
Created attachment 196037 [details] Conditions for the SAME cell range Attachment_2.jpg: Conditions for a single cell range CAN be re-ordered with "Up" and "Down" buttons.