Database Reference
In-Depth Information
24
Click
New Rule
to open the
New Formatting Rule
dialog box.
5
You can create rules that compare the current field value to a specific value or to other values in
the same field.
25
With
Check values in the current record or use an expression
selected as the rule
type, in the
Format only cells where the
area, click the arrow for the second box,
and click
less than
. Then in the third box, enter
1
.
26
In the
Preview
area, click the
Bold
button, and change the
Font color
setting to red.
Then click
OK
.
This rule for the Units In Stock field will cause values less than 1 to be bold and red.