Apply shading to alternate rows using Conditional Formatting

It is often easier to read lists of data if alternate rows are shaded. This article shows you how to use conditional formatting to shade alternate rows.

Apply shading to alternate rows using Conditional Formatting

  1. Select the Range (Eg: Cell A2 to Cell F30)
  2. Browse > Home tab > Styles group
  3. Click on the arrow next to Conditional Formatting
  4. Click on New Rule
  5. In the New Formatting Rule dialog box, under Select a Rule Type, click Use a formula to determine which cells to format
  6. In the Format values where this formula is true box,
    enter “=MOD(ROW(),2)=0”, as shown below
  7. Click Format
  8. In the Format Cells dialog box, click the Fill
  9. Select the background or pattern color that you want to use for the shaded rows, and then click OK
  10. The table looks in the following format

Download the example file: Apply shading to alternate rows – Conditional Formatting.xlsx

Also read 

Show Comments


  1. nandan-ediaryNandan
    • Raghu R

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.