I am currently working on a spreadsheet with 100+ conditional formatting rules on columns, and the formatting rules significantly reduce initial page load speed. I already implemented IMPORTRANGE()
, which pulls cell data from another sheet to avoid recalculating computed columns on load.
I would like to import the color data per-cell from another spreadsheet to avoid expensive conditional formatting on page load. Is there a method in Google Sheets or an external script to copy and update with the per-cell fill color from another sheet?