Jul 20 2021 06:43 AM - edited Jul 20 2021 10:24 PM
Hi community. I have the attached conditional formatting set up in a big table, where the duplicates value is in the top, as that have highest priority (picture 1). But, when I delete a row anywhere in the table, the duplicate value condition gets pushed to the bottom (picture 2). I have tried several times to move it back up, but this keeps happening. I cannot find anywhere how to prevent this. Please help!
Thank you in advance.
Kind regards, Kenneth
Jul 20 2021 08:11 AM
@kdravn_1 but you can change the order back to how you want it by selecting a rule and pressing the up or down arrows to the right of the "Delete Rule" button.
Jul 20 2021 10:24 PM