Conditional Formatting in Google Sheets

Conditional Formatting allows you to do things like painting a row in Google Sheets based on the input of one of the cells on that row. I use it a lot to color track when tasks are done for example. For example: To use it just select the whole working area and choose “Conditional Formatting”, […]

Read More

Zebra style on Google Sheets with conditional formating

Microsoft Excel and other programs in Microsoft Office provide a handy feature called “Quick Styles” to help you quickly format a selected range as a striped table. The table can have zebra lines meaning alternating rows are formatted with different colors. Google Sheets do not support zebra stripes (yet) but you can use conditional formatting […]

Read More