Hi guys!
Having trouble to figure it out how to quickly multiply checboxes who have specific conditional formatting and related cell. I made two checkboxes, first one makes certain cells in a row to color in red, then another checkbox which makes them green. Like is first one is checked job is not done yet, is I thick second one it becomes green as job done.
Now, if I just go to first cell with checkbox and pull it to multiple cells I get multiple checkboxes but they are linked to same cells in first row. What I would like to have checkbox in row 3 linked to cells in same row and not to row 2 from which is "original" checkbox...I hope you understand what I would like to do. Because I need 500 more checkboxes in colomn B and another 500 in colomn C and if I need to do it manully I need to quit my regular job. :P
Having trouble to figure it out how to quickly multiply checboxes who have specific conditional formatting and related cell. I made two checkboxes, first one makes certain cells in a row to color in red, then another checkbox which makes them green. Like is first one is checked job is not done yet, is I thick second one it becomes green as job done.
Now, if I just go to first cell with checkbox and pull it to multiple cells I get multiple checkboxes but they are linked to same cells in first row. What I would like to have checkbox in row 3 linked to cells in same row and not to row 2 from which is "original" checkbox...I hope you understand what I would like to do. Because I need 500 more checkboxes in colomn B and another 500 in colomn C and if I need to do it manully I need to quit my regular job. :P