Your Table::Wish to be called="YES"
would be the formula. Then select text color and select the red color you want.
This is pretty clear if you look it up in help or read the manual.
I tried this but got the message "The specified table cannot be found"
Is this because I did not use tables when setting up my database?
I can't see how you could set up a database and not use tables.
Maybe I did use tables... I'm just trying to muddle through as best I can as a beginner. Filemaker is not my major focus but I'm on a very tight budget and trying to do things myself. Is there anyone else out there who can help me out? I'm happy to answer any questions that might help move things along.
You have at least one table and it is likely the same name as the original name of your file when you first created your database. You can open Manage | Database | Tables and see the name of this table if you want.
To add the conditional format Rick suggested, do this:
- Enter Layout mode
- Right click your field (Shift click for Mac) and select conditional formatting.
- Click Add
- Select "Formula is" from the condition drop down.
- Click the Specify button.
- Double click the name of your field from the list of fields you see listed at the top of this specify calculation dialog to add it to your calculation. This will add the table's name and the field's name to the expression.
- Then add ="YES" after it and click OK until each dialog is closed and you are back on your layout.
- Enter browse mode and try it out.
Thank-you, Thank-you, Thank-you, PhilModJunk. I followed your great instructions and it worked like a charm. I'm so appreciative!