I have this Google Sheet document that already has functionality built in which applies automatic borders. I don't know how it is doing this. I've tried looking in the Script Editor, but I don't see any existing scripting in the Script Editor. Perhaps I'm missing something.

I would like to adjust the way it auto-applies borders. Currently, if you insert text in a cell in the "Cue Title" column, it applies a border to two cells down, through Column R. I'd like it to instead apply a top-border to the cell with text in it, through Column R.

There is other auto-functionality built into that document which I'd like to preserve, as well, so I'd like to correct the Google Sheet itself, rather than starting all over from scratch.

How do I adjust this functionality?

  • Are you able to identify the conditional formatting rules that are applying the borders in the Google Sheets conditional formatting tool?
    – Rubén
    Aug 26 '21 at 0:56
  • Yes, and this has brought me to a solution to my first post. Thanks
    – etudes
    Aug 26 '21 at 3:22

As I already said in my answer to your previous question, Google Sheets and the Google Sheets API hasn't a way to change the conditional formatting rules inherited from the Excel file that was converted into a Google Sheets spreadsheet.

One thing that you could try, first clear the conditional formatting rules that are applying the borders, then instead of using the conditional formatting built-in feature use an on edit or on change trigger to set the cell borders by using Google Apps Script.


  • My bad, I didn't understand that part of your previous answer. I see what you are saying now about some functionality being inherited in the background without a way to edit it. I've uploaded a second sheet in the linked document here with the conditional formatting stripped. As I mentioned in my previous post, I don't know how to write such a script using Google Apps Script. Perhaps you can help with this?
    – etudes
    Aug 26 '21 at 1:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.