Google sheet change tab color based on date comparing

Question

I have a google sheet that contains dates, I want to change all the tab color if the today date higher than the cell date

I have like 30 tab and each one has the same cell but different date

the cell position: A4

So cell A4 is every tab has a date in it and you wish to change the color of the tab if the date in A4 is older that todays date. Is that correct? If so what what colors do you want? Are there any tabs that you wish to exclude from this operation? — Cooper

Cooper Cooper · Accepted Answer · 2019-11-24T18:29:05

function changeColorIfA4IsEarlierThanToday() {
  var ss=SpreadsheetApp.getActive();
  var shts=ss.getSheets();
  var today=new Date(new Date().getFullYear(),new Date().getMonth(),new Date().getDate()).valueOf();
  shts.forEach(function(sh){
    var val=sh.getRange('A4').getValue();
    if(new Date(val).valueOf()<today) {
      sh.setTabColor('#ffff00');
    }else{
      sh.setTabColor(null);
    }
  })
}

Google sheet change tab color based on date comparing

1 Answers