I have some code that displays values from a record set. If the value is less than 8000, I wish to change the color of the displayed text. I tried this:
If (recordset(1).Value) < 80000 Then
font.color = &HFFEFEF
End If
But it didn't work. How do I do it?