You can also use a conditional formatting rule to apply different formatting to specific rows or columns. Here's how: 1 On the worksheet, do one of the following: - To apply the shading to a specific range of cells, select the cells you want to format.- To apply the shading to the whole worksheet, click the Select All button. Select All button on the worksheet 2 Click Home > Conditional Formatting > New Rule . Conditional...