microsoft excel spreadsheet shade every other row

#Microsoft excel spreadsheet shade every other row how to#

Once the formatting is applied, it’s a good idea to test it to make sure it’s working as expected. You should now see the odd rows in the range with the formatting you chose. This will cause the formatting to be applied to the range. Once you have selected the range and chosen the formatting, click the Format All Cells Based on Their Values option to apply the formatting. You can also apply other formatting, such as font size, number formatting, and more. Select the color that you want to use for the odd rows. Once you have selected the range of cells that you want to format, select the Format tab in the New Formatting Rule window. This formula will select all of the odd rows in the range. For example, if the range is A2:A10, you would enter the formula =MOD(ROW(),2)=1. Enter a formula that will select every other row in the range. In the New Formatting Rule window, select Use a formula to determine which cells to format.

To use conditional formatting to alternate row colors, select the range of cells you want to format, then go to the Home tab and select Conditional Formatting > New Rule. Conditional formatting allows you to set rules for how cells should look based on the data in them. The easiest way to alternate row colors in Excel without a table is by using conditional formatting.

#Microsoft excel spreadsheet shade every other row how to#

Here are some simple steps on how to alternate row colors in Excel without a table. While you can easily do this with tables in Excel, it can also be done without a table. One way to make a spreadsheet easier to read is by alternating row colors. Click OK and you’re done!Īlternating Row Colors in Excel without a TableĮxcel spreadsheets can contain a lot of data, and can easily become cluttered. In the formula field, enter the formula =MOD(ROW(),2)=0 and then select a color. Select the New Rule option, then choose the ‘Use a formula to determine which cells to format’ option. Then, select the Home tab and click on the Conditional Formatting button. First, select the cells you want to format. Alternate Row Colors in Excel Without Table: To alternate row colors in Excel without table, you can use the Conditional Formatting feature.