Borders in conditonal formatting

Question

I am looking to remove borders in cells AG64:BE68 on the below spreadsheet based on whether Cell AG64 is blank or populated. I am aware its not possible to do just using conditonal formatting but believe it is possible to do using google script. I have had a look at some other posts but have been struggling to understand how to change the formatting to just these cells and not the whole sheet. If somebody could advise that would be great

https://docs.google.com/spreadsheets/d/1_WYt6Kh536xmwW_qeUrYc0tklDQieuRUIPiYs6R6JPs/edit#gid=0

Answer 1

Use an onEdit(e) simple trigger and Range.setBorder(), like this:

/**
* Simple trigger that runs each time the user hand edits the spreadsheet.
*
* @param {Object} e The onEdit() event object.
*/
function onEdit(e) {
  if (!e) {
    throw new Error(
      'Please do not run the onEdit(e) function in the script editor window. '
      + 'It runs automatically when you hand edit the spreadsheet.'
    );
  }
  borderizeWildly_(e);
}

/**
* Draws borders around a range of cells when a cell in a magic column
* is edited and the new value in the cell is the word HEAT.
* Removes borders when a cell is cleared and the old value in the cell
* was the word HEAT.
*
* @param {Object} e The onEdit() event object.
*/
function borderizeWildly_(e) {
  // version 1.0, written by --Hyde, 16 November 2022
  //  - see https://webapps.stackexchange.com/q/167769/269219
  if (![e.value, e.oldValue].includes('HEAT')
    || ![2, 33].includes(e.range.columnStart)) {
    return;
  }
  e.range.offset(0, 0, 5, 25)
    .setBorder(...new Array(6).fill(e.value === 'HEAT'));
}