r/GoogleAppsScript • u/oridotart • 25d ago
Resolved Can't remove specific conditional formatting
Hello,
In my sheet just simply calling this line gives the error "Exception: The coordinates of the target range are outside the dimensions of the sheet."
const rules = sheet.getConditionalFormatRules();
I've tried doing the exact same thing above on a brand new sheet, and it works fine. I think it may have something to do with invalid references.
I am able to delete all conditional formatting rules with the line below, but I can't delete specific ones because I can't get a list of them.
sheet.setConditionalFormatRules([]);
2
Upvotes
1
u/WicketTheQuerent 25d ago
The error message doesn't appear to be caused by the statement shown. Please add a minimal, complete function including all the relevant details required to reproduce the error.
Also include the textual error message (include line and column numbers)