gs conditional formatting - Adding new Rows changes Range cells in Google Sheets, skips new row -

The original question was here and the answer to which I thought was:

But for a month or this For use, I'm still running the issue of conditional format that changes the values ​​in "Range:" when adding a new row. For example, if my formatting is for the entire column B and then I will be in line 35 If I add a line, conditional formatting is now in B1: B34 range, and punk End 35 has no formatting.

The solution was to put this code in the Google Sheet's script editor.

  function formatting () {var ss = SpreadsheetApp.getActiveSpreadsheet (); Var sheet = ss.getSheetByName ("Sheet1"); Var Range = Sheet.Titrange ("A1"); Range copyFormatToRange (sheet, 1, sheet.gettest column (), 1, sheet.tstlest ())}  

Again, a new line is added to the sheet at any time , The conditional formatting range changes information and leaves the new line.

If the formatting and whole column is possible, then it can be completed code:

  function column background () {var ss = SpreadsheetApp.getActiveSpreadsheet (); Var letter = ss.getSheets () [0]; Var Category = Sheet.GetRenz ("B: B"); Range.setBackground ("Red"); }  

The above code formats the background of whole column B in red.