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? Commented Aug 26, 2021 at 0:56
  • Yes, and this has brought me to a solution to my first post. Thanks
    – gills
    Commented Aug 26, 2021 at 3:22

1 Answer 1


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.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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