Formatting in Report

[ConfusedMay]

Hi,

I have an access report that consists 2 txtbox fields which are total actual and total estimate. What I need is if total actual > total estimate change the backcolor to red. I created an if and then statement, the only problem is that it didn't check the whole records, it only check the first record and change the whole 2 fields to red for the whole report regardless the value on the next record, then I changed the if and then statement to case for looping but it didn't even change color now. Please help... I'm new in VBA
here is my case statement:

Private Sub Report_Activate()
For a = 1 To nrecord
 
If txtactual.value > txtestimate.value Then results = x
 
If txtactual.value < txtestimate.value Then results = y
 
    Select Case results
        Case x
 
            txtactual.BackColor = 255
 
            txtestimate.BackColor = 255
 
 
        Case y
 
            txtactual.BackColor = 12632256
 
            txtestimate.BackColor = 12632256
 
    End Select
 
Next i
 
 
   End Sub

[MMcCarthy]

In report design view click on the textbox that you want to change colour. Now go to the Format menu and choose Conditional Formatting. Change the condition to Expression is and enter

txtActual > txtEstimate

then set the format for the fill colour or text colour if the condition is true.

Mary

[ConfusedMay]

In report design view click on the textbox that you want to change colour. Now go to the Format menu and choose Conditional Formatting. Change the condition to Expression is and enter

txtActual > txtEstimate

then set the format for the fill colour or text colour if the condition is true.

Mary

It worked thank you......

[MMcCarthy]

It worked thank you......

You're welcome.