Formatting text boxes on report

N

Newbie

Hi

I have a report which has a textbox - txtSales

based on the status of a customer I wish the background to be a color

eg. Customer A - status = 9 - txtSales to have a background of green

How can I accomplish this?
 
Top