Hit OK again in New Formatting Rule window to implement the rule. Then click Format… on the lower right corner.ĥ. Enter the formula “ =mod(row(),2)=0” in the textbox below Format values where this formula is true. Select Use a formula to determine which cells to format as the rule type.Ĥ. Switch to Home tab, click Conditional Formatting and choose New Rule… in the drop-down list.ģ. First, select the range of cells you want to shade.Ģ. How to Shade Every Other Row in Excel with Conditional Formattingġ. Here I’ll introduce 2 commonly used methods to make a table like this. It can make the data more vibrant and easy to distinguish. You must have seen some Excel spreadsheets with alternating colors in rows or columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |