Hello everyone,
Is there a way to lock only selected formatting parameters while leaving others editable? I'm looking for a way to have background pattern and border thickness set up and fixed for certain ranges in spreadsheet and so when copying/pasting/moving cells around, the content and background color moves with it while borders and pattern applies depending on what range the cell is being moved/copied to.
for example: in row 1 there is no pattern and thick border, in row 2 there is pattern and thin border. When moving cell from row 2 to row 1, I need background color and text to be moved but borders and pattern to be applied as specified per row.
Is there a way to lock only selected formatting parameters while leaving others editable? I'm looking for a way to have background pattern and border thickness set up and fixed for certain ranges in spreadsheet and so when copying/pasting/moving cells around, the content and background color moves with it while borders and pattern applies depending on what range the cell is being moved/copied to.
for example: in row 1 there is no pattern and thick border, in row 2 there is pattern and thin border. When moving cell from row 2 to row 1, I need background color and text to be moved but borders and pattern to be applied as specified per row.