ja6lee

function onEdit(e) {
  var range = SpreadsheetApp.getActiveSheet().getDataRange();
  for (var j = range.getColumn(); j <= range.getLastColumn(); j++) {
    for (var i = range.getRow(); i <= range.getLastRow(); i++) {
      var cell = range.getCell(i, j);
      var status = cell.getValue();
      if (status[0] == '#') {
        cell.setBackground(status);
      } else {
        cell.setBackground('#ffffff');