Select the cells that you want to format with an alternating gray and white
row.

FOrmat - COnditional Formatting

Set your condition to Formula is =mod(row(),2)=0 and set the shading you
want.

"LisaD" wrote:

I am creating a spreadsheet similar to a school attendance record so I have a
white row and then a gray row. When I enter the children's names and run a
sort to put them in alphabetical order, it also sorts the cell format. Is
there anyway to make the form permanent and just the data sortable?