Conditional rows formatting in Google Docs Spreadsheet

gistfile1.js

var styles = {
  'default': {
    color: '#000',
    background: '#fff',
    style: 'normal'
  },
  sent: {
    color: '#ccc',
    style: 'italic'
  },
  asked: {
    color: '#974841',
    background: '#EBCA9D'
  },
  answered: {
    color: '#4F6228',
    background: '#9BBB59'
  }  
};

function onEdit(event) {
  var sheet = event.source.getActiveSheet();
  if (sheet.getSheetName() != 'Обязательно')
    return;
  
  var rowIdx = event.source.getActiveRange().getRowIndex();

  if (getCellValue(sheet, rowIdx, 'F') == 'Да')
    appyStyle(sheet, rowIdx, 'answered');
  else if (getCellValue(sheet, rowIdx, 'E') == 'Да')
    appyStyle(sheet, rowIdx, 'asked');
  else if (getCellValue(sheet, rowIdx, 'D')) 
    appyStyle(sheet, rowIdx, 'sent');
  else
    appyStyle(sheet, rowIdx, 'default');
}

function getCellValue(sheet, row, col) {
  return sheet.getRange(col + row).getValue();
}

function appyStyle(sheet, row, name) {
  var style = styles[name];
  var defaults = styles['default'];
  var range = sheet.getRange(row, 1, 1, sheet.getLastColumn());
  range.setFontColor(style.color || defaults.color);
  range.setBackgroundColor(style.background || defaults.background);
  range.setFontStyle(style.style || defaults.style);
}

gistfile2.txt