How to gray-out every other row?

I am working in a limited range of cells, 1 through 30, & columns A through G. How can I format this area so every other row is highlighted light gray?

Do you mean AutoFormat?

GrayRows

2 Likes

Worked great! Thank you : )