Database Reference
In-Depth Information
To show a formula-based conditional formatting rule, you'll add conditional formatting to
your database in a surprising place. Take a peek at
Figure 15-13
to see the problem you need
to fix.
Figure 15-13. Take a look at the text under Robert Johnson. You see two extraneous commas float-
ing in the middle of nowhere. These commas separate the address, city, and state in the address
line. In this case, all the address fields are empty, so just the commas show up.
Most people wouldn't think of it right away, but conditional formatting can help clean up a
little mess like commas between empty fields. If the address fields are empty—and that's a
condition—you don't want the commas to show up. FileMaker doesn't have the power to
