How to conditionally colour text boxes

[abhi1693r]

I have a text box with formula, ='Status' is & if([Report]='X','Required','Not Required').

I want the color of the to turn green when Required is displayed. 

Thanks

[olivetwist · Accepted solution]

In the object properties on the General tab, click the Colour box under Background. Choose Calculated under Base colour. =IF(Report='Required',GREEN()).