Technology Insights

Google Docs: Add Background Color To Every Other Row On a Google Spreadsheet

Google Docs is a great tool for storing spreadsheets and other documents because it provides an centralized storage space for all of your documents which can be shared with users and accessed from any where that has an Internet connection. One thing that can be really helpful when creating a Google Spreadsheet is having a unified format to the entire document. A format that can assist in making the data in the spreadsheet easier to read is alternating colors for every row. This way if you have lots of columns per row you can easily see which data belongs to each row. The directions below explain how to set up formatting for two rows and then apply that formatting to the rest of the Google spreadsheet.