Color

Alternate Row Color

Image Posted on Updated on

When you’re displaying data in a Table or Tabular, sometimes the report may look very busy to the eyes. By alternating the row colors, the results will look more easy on the eyes. Here’s how you do it.

Here’s our “Before” results
0

Step 1: Click on the Design tab

1

Step 2: Click on the detail row. In the BackgroundColor drop-down, select “Expression”

2

Step 3: Type this  =IIF(RowNumber(Nothing) MOD 2,”White“, “Silver“)

Step 4: Preview the report

3

Advertisements