SSRS: Conditional Font Color

Denoting data trends by applying logic-controlled formatting, for example, employees with the most amount of accumulated Sick Leave.

To illustrate how to apply specifying formatting based on values, I’ll begin with a dataset that returns employee data.


By viewing the resultset, it’s difficult to discern any distinguishable trends in the data.

To denote those employees with over 40 hours of sick leave, I’ll assign a test for the field’s Font color property that will use a red color is Sick Leave is over 40 or it will remain black.



For the Font Weight property, I’ll assign a similar function that will make the same text bold or leave it normal.


By executing the report, I can now more easily tell which employees have over 40 hours of sick leave because their hours are red and bold.


Download Report

(right-click, Save As)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s