Change colour of text field in report when data = preset 1

[aph]

Hi all I have a colum report that has a number of headers for the data E.G Date, Operator, Quantity, Disposition what I want is when the Disposition field data = "Scraped" (this is an text input drop down from a form)then that in the Report is highlighted red.

I have doenthis before but cannot remmber how I did it only that the way I did it is limited to only 4 occasions of changes to the text colour.

 

[BTSTeam]

Are you thinking of Conditional Formatting?
(Right-click on the text box and select "Conditional Formatting")

Andy

 

[aph]

Cheers Andy thats what i was trying to think of the name of