Alternate Row Shading in Google Sheets Using ISEVEN and ROW

Back to list

You select the region of interest and then

Format > Conditional Formatting

Now, in the new dialog that showed up on the right, you have to change the dropdown below the "Format Cells if" to "Custom Formula is" and there, type in "=ISEVEN( ROW() )" (no quotes, yes = sign).

Thanks Google for making this so hard. Whoever thought something from you would be worse than what M$ sells?

Education is not the filling of a vessel but the kindling of a flame (Socrates), so here goes :

https://support.google.com/docs/table/25273?hl=en