How can I shade every other row in Spreadsheet automatically?

U

UABCSA

I would like this to auto format based on all odd or even numbered rows for
easier viewing of a task list. Sometimes items (rows) are deleted or added.
Can this autoformat?
 
B

bj

one common way to do this is select all <Format><Conditonal format>
<Equation = > = mod (Row(A1),2)=1 then select your prefered color
note you sometimes need to go back in and get rid of Quote marks or absolute
cell references. I do not know why.
 
Top