Go to Conditional Formatting, set the drop down to Formula is: =MOD(ROW(),2)=0 That will apply your selected format to odd rows.
Nice. From Five Favorite Excel Tips
Using Conditional Formatting to Create Alternating Color Rows in Excel
by
Tags:
Go to Conditional Formatting, set the drop down to Formula is: =MOD(ROW(),2)=0 That will apply your selected format to odd rows.
Nice. From Five Favorite Excel Tips
by
Tags:
Leave a Reply