Sheets Dark Mode as Conditional Format

[Alan Wells]

Google Sheets for the Web Browser doesn't have a dark mode.

I don't know if mobile has it.

But you can implement your own "dark mode" either manually or with some code.

function formatAllCellsBlack_() {
try{
  var range,rule,rules,sh,ss;  
 
  ss = SpreadsheetApp.getActiveSpreadsheet();
  sh = ss.getActiveSheet();
 
  range = sh.getRange("A2:Y1000");
 
  rule = SpreadsheetApp.newConditionalFormatRule()
    .whenCellEmpty()
    .setBackground("black")
    .setRanges([range])
    .build();
 
  rules = [];
  rules.push(rule);
 
  rule = SpreadsheetApp.newConditionalFormatRule()
    .whenCellNotEmpty()
    .setBackground("black")
    .setRanges([range])
    .build();

  rules.push(rule);
  //Logger.log('rules: ' + JSON.stringify(rules[0]))
 
  sh.setConditionalFormatRules(rules);
 
  range.setFontColor('white');
}catch(e) {
  Logger.log('Error: ' + e.message)
 
}
}