see posting on this topic, earlier today.

select the rows you want shaded. go to conditional formatting.
formula....=mod(row(),2) and select the shading color you want.

"viper2000ss" wrote:

How do I keep every other row shaded when I sort data?