Conditional Formatting of Fields in Paginated Reports

[Anonymous]

Good Day,

I have created a Power BI Paginated Report using Report Builder.  One of the fields that is in my report needs to have color associated with the TEXT in the field.  So for example - if the field says "ON HOLD" the FONT Color needs to be RED.  Is this possible at all with Paginated Reports?  I've searched for videos, etc., but can't find anything specific.  Any suggestions or links to documentation that I could read?

Thanks

[Anonymous]

@Anonymous 

Glad you fixed it, and Thanks for sharing, people with same question could find the solution quickly.

Paul Zheng _ Community Support Team

[Anonymous · Accepted solution]

Thank you all - I figured it out by doing nested IF statements in the Background field. Here is what I used in case there are others out there trying to figure this out. Background Color Expression:   =IIF(Me.Value="Ongoing Company Contact", "Green",IIF(Me.Value="On-Hold", "Red",IIF(Me.Value="In-Progress", "Yellow", "Black")))