I read elsewhere that there's a bug with conditional formatting involving placeholder text, but I'm experiencing a similar issue where I have a FromDate and ToDate (both are Date fields) where I want the field to turn yellow if the To date is before the From date _if_ the To date is not empty. (The yellow fill is to alert a user that they mis-entered a date.)
If I use the calculation, "FromDate > ToDate"--the conditional formatting calc works. However, when I change the calculation to
"FromDate > not IsEmpty ( To Date)", the calculation fails.
Am I missing something, or is this part of the aforementioned bug? I've attached a FileMaker Pro v14 test file, created with a Mac.