How do I in another scenario, after ticking a check box (Example row 20) then it will proceed to move up to row 2? The scenario is that I will have lets say 30 row of random data, and a check box on each row, after I check, it will rearrange to the top. So if I check row 20 now, it goes to row 2, I check row 15, it goes to row 3, I check row 21, it goes to row 4 and so forth? Cause I want to keep track in order the task I did after checking everything.
Just replying late in case anyone like me is watching this is 2024! The correct formula in relation to checkboxes is =AND($C2=TRUE, $D2=TRUE). You can add as many checkboxes as you like and the formula won't format any of your selected range unless ALL of them are checked.