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
    ConditionalFormating01
  4. Click on New Rule
    ConditionalFormating02
  5. In the New Formatting Rule dialog box, under Select a Rule Type, click Use a formula to determine which cells to format
    ConditionalFormating03
  6. In the Format values where this formula is true box,
    enter “=MOD(ROW(),2)=0”, as shown below
    ConditionalFormating04
  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
    ConditionalFormating05
  10. The table looks in the following format
    ConditionalFormating06

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

Also read 

Show Comments

2 Comments

  1. nandan-ediaryNandan
    • Raghu R

Leave a Reply