1 of 1 people found this helpful
This Only Happens When There is More than One Record associated with the records account number.
I recommend a more detailed description of the conditional format expression and the tables/relationships involved.
At a guess, you have multiple records in a related table and your conditional format expression is only checking the value of the first related record and not that of any subsequent related records created later. If so, there are ways to modify either the relationship or the expression used to reference the data in the related records in order to only check the most recent record out of the set of related records.
Max ( RelatedTable::Date )
Comes to mind as one way to check the most recent date out of a set of related records--but other options are possible and a more sophisticated approach could be needed if other details not yet posted are involved.
This Was it,