How do I keep every other row shaded when I sort data?
J Jonathan Cooper Apr 5, 2006 #2 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.
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.
