I am using this code:
Case ( Amt > 0 ; TextColor ( Amt ; RGB ( 0 ; 254 ; 0 ) ) ;
Amt = 0 ; TextColor ( Amt ; RGB ( 0 ; 0 ; 0 ) ) ;
Amt < 0 ; TextColor ( Amt ; RGB ( 254 ; 0 ; 0 ) ) ;)
to change the text color based on field content.
I tried the F1 help to see if there was a similar method to change the FILL color of a field based on content, but I found nothing. Can that be done as well.