Skip to main content

You can also use the paint format tool. Highlight the row after you've changed the color, click the icon that looks like a paint roller, then click the next row you want to change color too (as long as it's okay if the rest of the format of both those rows are the same.) It's annoying to have to do it repetitively, but it's slightly faster than selecting the color for each row.

  • If you do this before adding data then the other format changes will go on top.

  • The main problem with this method if you insert rows later it will offset everything unless you insert a pair of rows and format it the same.

hopefully Google will add formulas to conditional formatting soon.

You can also use the paint format tool. Highlight the row after you've changed the color, click the icon that looks like a paint roller, then click the next row you want to change color too (as long as it's okay if the rest of the format of both those rows are the same.) It's annoying to have to do it repetitively, but it's slightly faster than selecting the color for each row.

You can also use the paint format tool. Highlight the row after you've changed the color, click the icon that looks like a paint roller, then click the next row you want to change color too (as long as it's okay if the rest of the format of both those rows are the same.) It's annoying to have to do it repetitively, but it's slightly faster than selecting the color for each row.

  • If you do this before adding data then the other format changes will go on top.

  • The main problem with this method if you insert rows later it will offset everything unless you insert a pair of rows and format it the same.

hopefully Google will add formulas to conditional formatting soon.

Source Link

You can also use the paint format tool. Highlight the row after you've changed the color, click the icon that looks like a paint roller, then click the next row you want to change color too (as long as it's okay if the rest of the format of both those rows are the same.) It's annoying to have to do it repetitively, but it's slightly faster than selecting the color for each row.