A while back somebody had asked about the conditional changing of field
fill colors. I haven't looked into that, but some might find this
useful, or not:

The following Case function tests the value of a data field, and if it
is greater than or equal to a specified value, it prints the number in
red. If it is less than or equal to a specified value, it prints the
number in blue. If the number is within range, it prints in black.

Case ( DATAFIELD „ 138 ; TextColor ( DATAFIELD ; RGB ( 255 ; 0 ; 0 ) ) ;
DATAFIELD ¾ 98 ; TextColor ( DATAFIELD ; RGB ( 0 ; 0 ; 255 ) ) ;
TextColor ( DATAFIELD ; RGB ( 0 ; 0 ; 0 ) ) )

In article <jsutphin-4D0150.01014721082010 (AT) news (DOT) windstream.net>,
James Sutphin <jsutphin (AT) windstream (DOT) net> wrote:

Recent version of FMP -- starting with 9, I think -- have Conditional
Formatting, which provides for changing of various formatting aspects
depending on conditions. The user selects the field or object, specifies
the condition to trigger the formatting and specifies the formatting to
be used based on the conditions. Conditional Formatting is a choice in
the Format menu when you are in the Layout mode and have selected a
field or other object.

See the Help file and user guide for more details

Of course if you are hosting your database on a network, users of
earlier versions of FileMaker will not see the effects of conditional
formatting -- just like any other new feature not supported on earlier
versions.