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.
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.
Thank you for posting this! The video uploaded a little blurry so it's hard to see the formula. Is it =AND($A2=1, $B2=1)? Thank you!
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.
Thank you
Is there a way to contact you for help outside of comment section?
Probably not my guy