I do this on FMP8 by using three fields:
1. The Date field
2. Calculation: If (Table:: Date < Get(CurrentDate) ; Table:: Date ; "")
3. Calculation: If (Table:: Date >= Get(CurrentDate) ; "" ; Table:: Date)
(extra spaces used to avoid emoticons on this forum)
This lets two calc fields split your date field around the current date.
Put both fields on top of each other in the layout.
Make the Past due field Red/Bold/Italic, whatever...
Only one of the two fields should ever contain data at any given time.
Note: This approach presupposes that the date field NEVER needs to be modified via this particular layout. If the date needs to be changed, it should be changed on another layout or via script using custom dialog.
The other old version method for this is to make your field transparent and place a calculation field behind it that returns the contents of a container field if the calculation evaluates to true. You then paste a colored rectangle into the container field (Do all this on another layout) to enable a "highlight" color.
The advantage to this method, is that now your data field can be edited and yet you still can have conditional highlight colors appear.
It leaves data entry option open.
It's more build-intensive, but more user-friendly for data entry/edit.
Not sure how to "paste a colored rectagle". ?
Draw a rectangle in layout mode, copy ( or cut ) it, go back into browse mode, paste it into the container field.
Okay....just like it sounds! Thanks.
There are also format options on the container field (after you place it on the layout) that will automatically resize the rectangle to completely fill the container without having to perfectly match the field size or proportions.