This does not give me the ability to alternate colors. What am I doing wrong?


Bernard Liengme wrote:
Use Format|Conditional Formatting rather than 'hard" colours.
Select the range of row to format and use
Formula Is =MOD(ROW(),2)=1 and select some pattern colour
best wishes
I have set up an excel file in which I have colored every other line grey.
I
[quoted text clipped - 6 lines]

Thanks!