AnsweredAssumed Answered

Changing text colors based on multiple conditions

Question asked by SallyMasterton on Feb 1, 2011
Latest reply on Feb 1, 2011 by SallyMasterton

Title

Changing text colors based on multiple conditions

Post

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.

Thank you.

Outcomes