Skip to content
 

Shade Alternate Lines in a Report

 
 

Tabular data can be tough to read; I frequently want my reports to have alternate lines shaded to make the data easier to follow.

 
 

Shading Alternate Details Lines

  1. Right-click the Details section name.
  2. Select Section Expert.
  3. Click the color tab and click the Conditional Formatting button.


  4. To shade every other line, enter the formula

    If RecordNumber Mod 2 = 0 Then crSilver else crNoColor

    To shade every two lines, enter the formula

    If RecordNumber Mod 4 in 1 to 2 Then crSilver else crNoColor

  5. Click OK twice, and preview your report.


     
     

Leave a Reply