0

I have a shared spreadsheet that users can edit data in. The only problem is, that whenever someone copy and pastes data, the format changes, and I'm always going in to fix it (somewhat of a pain).

I saw a similar question, where a script was created to copy formatting from a locked row to the other, editable rows. However, I need something that will do the same but with columns. I'm bad with scripts, so I'm not sure how to do this. It would probably be easy just to alter the script described there. I need it to only have the same format as the first column since each row alternates format. Could someone edit it to only include formatting based on columns?

And even when I try to run that script in Script Editor, it gives me "This App Isn't Verified." Here's a link to the post.

  • The referred post answer is long but it includes "Column Formula Protection". I think that it's what you are looking for. – Rubén Apr 26 '18 at 23:56
  • Okay, thanks for the response. I'm a little ignorant - it seems that the script given, even in the "Column Formula Protection", was the same as that of Row "Format Protection." I can't use the row based system because my rows alternate format. And even when I try to run the script in Script Editor, it gives me "This App Isn't Verified." I need help. – Isaac R May 1 '18 at 4:32