Waffle Bytes

I have a fairly large spreadsheet we use to track requests for record transfers.  I've discovered recently that some of our larger schools are starting to use it to create internal requests.  This is fine, except when I am skimming through to make sure nothing is being overlooked I end up spending time on these internal requests, when I can bypass them. Hence, a short little script that will compare 2 data points in a row, then shade the row a particular color if the comparison is true. What the Script Does: It compares the values from two different columns to see if the first one is part of the second one - in this specific case it is checking the sending district against the receiving district.  If it is, then the row containing this record is shaded. The Script Here is the script I created to accomplish this - function setRowColor() {     var sheet = SpreadsheetApp.getActiveSheet();     var range = sheet.getDataRange();   ...

Many people do not know that they can change the color of their calendar.  This is especially helpful if you are both visual and maintain multiple calendars.  And...it is very easy to do. Here is a video on how to change a calendar's color, if you prefer. First, if you are viewing your calendar in full screen, click the "pancakes" (three stacked bars) to view the mini-calendar and list of all your calendars - For the calendar you want to change color of, mouse over until the "Options" pop-up (also called the "More menu" - the three stacked dots) - Click on the Options, and then you can select the color you wish the calendar to be - If the provided colors are not enough for you, click on the plus under the colors - You will be able to pick from a million plus colors.  Literally.

One popular request I often get from people that are looking at large sheets with lots of data is how to alternate the color of the rows to make it easier to read across and not lose your line.  Setting alternating colors is very easy with Google Sheets.  Simply - 1. Highlight the columns you want to assign alternating colors to 2. Go to the Format Menu and select Alternating colors... (towards the bottom of the menu) 3. Set your formatting -  A. Choose if you have a header and/or footer on your sheet - it will use darker highlights on those cells  B. Select the Formatting styles that are preset OR click on the + to create a custom style  C. Make any modifications you would like to the colors (Note: if you selected a preset style, as soon as you make a color change it will create a custom style) 6. Click Done If you want to remove alternating colors, go back to the Format Menu and select Alternating colors... and at the bottom of the ...