Changing text colors based on multiple conditions
I am a new to setting-up anything in FileMaker. I am currently on version 10. I would appreciate any help!
I have a "Final Due" field that contains a date.
I have a "Project Status" field that contains the following choices: live, on hold, cancel, done.
This is what I would like to do and have not been able to figure it out.
If the "Final Due" date is more than 10 days ahead, the date's text color should be green.
If the "Final Due" date is less than 5 days ahead, the date's text color will be orange.
If the "Final Due" date is less than 2 days ahead or is past due, the date's text color will be red.
If "done" is in the "Project Status" field, the text color in the "Final Due" date field should be black.
Basically, I'm trying to give warnings on due dates approaching or past due and turn off the warnings once the job is done.