Google Sheets – How to Make Active Sheet’s Tab Stand Out

accessibilitygoogle sheets

On my screen the active tab, Quotes, is just barely darker than the other tabs. How can I make the currently active tab stand out better?

(I have my screen adjusted for photo editing, so it is somewhat lower contrast to allow me to see the difference between black and very dark grey.)

Best Answer

Sorry, native customization of the standard interface is not a feature of Sheets. Despite their size, Google still say they welcome feedback. If you have a problem with a Google product, especially related to accessibility, choose Report A Problem from the Help menu and tell them about it.

Okay, with that said, this is totally doable. Further, because of how websites are delivered to browsers, the editing possible here is possible on almost every site. The coloration and other style settings of elements of webpages are just determined by a plain text list of "CSS" rules (see: tutorial) sent to your browser along with the page.

div.docs-sheet-tab:not(.docs-sheet-active-tab) {
  background-color: #484848 !important;
}

The the above CSS rule, for example, selects tabs other than the active tab, and forces them to have dark gray backgrounds.

Making a specific recommendation for editing style sheets in your browser is a bit off topic in this site, but if you think this approach is suitable, now at least you know it's an option, and what to search for. I captured the above-pictured alteration after modifying my Firefox profile's userContent.css (see: intro, ancient but first-party article, wiki page, tutorial on even editing the browser GUI), but the same could be achieved through other methods like browser add-ons (Firefox, Chrome, Safari, Opera).

Related Solutions

Google Sheets – Make Code Sheet Name Specific

If I interpreted your question right you want your script run only if you edit a cell in one of the three sheets you mentioned.

You can use getName() on actSht to get the name of the sheet in which you have edited a cell. The you can just use an IF-statement to check if it's one of your sheets.

Here's an example of what I described above:

function onEdit(e) {
  var sheet = SpreadsheetApp.getActiveSheet();
  if (sheet.getName() == "Project" || sheet.getName() == "Tasks"){
    //Some code that only runs if the cell edited is in a sheet named "Projects" or "Tasks"
  }
}

And here's how you can apply it to your code:

function onEdit(event)
 {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var actSht = event.source.getActiveSheet();
    if(actSht.getName() == "Active Tickets" || actSht.getName() == "Closed Tickets" || actSht.getName() == "Pipeline"){

        var actRng = event.source.getActiveRange();

        var index = actRng.getRowIndex();
        var dateCol = actSht.getLastColumn();
        var lastCell = actSht.getRange(index,dateCol);
        var date = Utilities.formatDate(new Date(), "GMT-3", "dd/MM/yyyy HH:mm");

        lastCell.setValue(date);
        lastCell.setComment("Ultima Modificacion: " + actRng.getA1Notation() +' por     '+Session.getActiveUser());
        ss.toast('Ultima Modificacion = '+ actRng.getA1Notation()+' por   '+Session.getActiveUser());
    }
}

Google-sheets – How to share only one tab in the new Google Sheets

By trial and error I managed to do this with 2 separate spreadsheets. Using the IMPORTRANGE feature I copied the full sheet 1 to the second document, and in the second document I created the second sheet.

Tricky but working

Best Answer

Related Solutions

Google Sheets – Make Code Sheet Name Specific

Google-sheets – How to share only one tab in the new Google Sheets

Related Topic