Mac OS 10.11.6
I have an issue where conditional formatting in a file I am working in is evaluating from the bottom to top instead of top to bottom. I have 2 fields, one called status ( text ) and the other called flag_invoice ( number ) . When an invoice is created it sets the flag_invoice to 1 so attached images show the conditional formatting and the output. If the status is "Open" it fills orange and invoiced fills green. Previously the status field wasn't being set to "Invoiced" but since that has been updated this isn't a problem with this scenario.
I have tried it with another table in the file and choosing to random fields to add formatting on the button with the same results. I have not tested this in a another file as of yet.