Conditional Formatting with SSRS


An important part of any report is formatting, to both ensure that it is easily readable but also that key information can be quickly and easily identified. In this article I’ll be covering how you can change the formatting of a cell in a tablix or matrix based on it’s value, or other values in the row, just like you are likely already accustomed to in Microsoft Excel.

I’m going to start off with the base template SSRS uses in Visual Studio 2017. This is quite a « bland » format, with headings in grey and just horizontal lines in the tablix.