Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In the object properties on the General tab, click the Colour box under Background. Choose Calculated under Base colour. =IF(Report='Required',GREEN()).
In the object properties on the General tab, click the Colour box under Background. Choose Calculated under Base colour. =IF(Report='Required',GREEN()).