Then enter the following formula that uses the MOD and ROW functions: =mod(row(),2)=1 When the Conditional Formatting window appears, select " Formula Is" in the drop down. Under the Format menu, select Conditional Formatting. In this example, we've selected all rows in the spreadsheet. Question: How can I set up alternating row colors in Microsoft Excel 2003/XP/2000/97? I don't want to have to change the row colors every time I insert, delete, or move a row.Īnswer: If you wish to set up alternating row colors in Excel, first highlight the rows that you wish to apply the formatting to.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |