conditional format rules - knowsheets.com

Alternating Colors Every 2 (or 3) Rows in Google Sheets

November 24, 2022 by Dave

Adding alternating colors every 2 rows in Google Sheets is easy. Simply open the menu and click Format > Alternating colors. Select a color scheme or theme and you’re done! But what if you want to alternate colors every 3, 4 or even 5 rows? You can’t do that using the in-built menus. Your best … Read more

How to Copy Conditional Formatting in Google Sheets

November 23, 2022 by Dave

You’ve spent some time getting your conditional formatting rules just perfect. But now you need to apply them to another column or range of cells in your sheet without affecting the data in those cells. You just want the formatting duplicated. How do you do it? You have 2 options. You can use the format … Read more