---
title: "How to alternate row colors in SSRS Tablix reports?"  
description: "How to alternate row colors in SSRS Tablix reports?"  
author: "Austin Luthar"  
published: 2026-09-01  
updated: 2026-09-01  
canonical: https://answers.mindstick.com/qa/117136/how-to-alternate-row-colors-in-ssrs-tablix-reports  
category: "SSRS"  
tags: ["ssrs", "expressions", "tablix", "formatting"]  
reading_time: 1 minute  

---

# How to alternate row colors in SSRS Tablix reports?

Creating readable reports often requires zebra-striping (alternating row background colors) across data rows in a Tablix control.

### How to set alternating colors in SSRS:

Select the detail row of your Tablix table, open the **Properties** window, and set the `BackgroundColor` property to an expression:

```
=IIF(RowNumber(Nothing) Mod 2 = 0, "Gainsboro", "White")
```

### How it works:

- `RowNumber(Nothing)` returns the sequential row index for the current scope.
- `Mod 2` calculates the remainder when divided by 2.
- `IIF` assigns "Gainsboro" for even rows and "White" for odd rows.


---

Original Source: https://answers.mindstick.com/qa/117136/how-to-alternate-row-colors-in-ssrs-tablix-reports

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.