You've probably seen tables with alternating row colors in some applications. The alternating row colors are normally added for readability purposes. You would notice that wide tables with multiple columns are easier to read when the colors of their rows are alternate.
Let's make the row color alternate between two colors: silver and yellow.
BackgroundColorproperty and set it to an expression (from the drop-down list select Expression).
=IIF(RowNumber(Nothing) Mod 2 = 0, "Silver", "Yellow")
In previous example, the
IIF function is a decision function that returns a Boolean Value (
False) depending on the criteria (whether ...