Database Reference
In-Depth Information
You can configure your condition in two different ways. Either you place simple rules
on the value of a field, or, if your needs are more complex, you use a
formula
. You'll
start with the easy kind.
4.
From the second pop-up menu under Condition, choose “equal to.”
In this case, you want the conditional formatting to apply when the Status is “De-
ceased,” so you tell FileMaker that's the kind of comparison it should do.
5.
To the right of the pop-up menu, in the box, type
Deceased
.
Here's where you enter the comparison value. (If you choose a comparison type other
than “equal to,” then the dialog box may show you different options.)
FileMaker adjusts the display of the dialog box so that the condition line reads like a
meaningful sentence: “Value is→equal to→Deceased.”
6.
From the Fill Color pop-up menu, choose a dark red color. Then from the Text
Color pop-up menu, choose white
.
As soon as you make a selection from either pop-up menu, FileMaker turns on the
checkbox to the left of its label. This checkbox tells FileMaker you want it to go
ahead and apply this style when the condition is met. If you decide you don't want to
change the fill color after all, you can simply uncheck the box.
NOTE
You don't have to provide any formatting rules for other values in the Status field. When
none of the conditions in the Conditional Formatting dialog box apply (you can add as many
as you want), FileMaker leaves the object formatted as it is in Layout mode, so you don't
need to add a condition for the
normal
case.
7.
Click OK
.
The Conditional Formatting dialog box disappears, and your field now sports a
Conditional Formatting
badge
. That little red and blue diamond on the right side of
the field lets you know Conditional Formatting is used on this field.
Although the layout looks unchanged, if you switch to Browse mode, then you see it works
as advertised. The status field of each person with a status of Deceased appears in red.
