This is odd to me, because I had this working in another layout. Given a series of fields (1-5) for example. I would like fields 1-4 to change fill colors if field 5 is empty. I selected conditional formatting for field 1. Selected "Formula is". Specified IsEmpty(File::Field 5). Selected new fill color. When exiting exiting layout, all records withing field 1 remain the base color, even tho 1/2 records in Field 5 are empty.
Please note, in Field 5, the "Value is" empty will trigger the change. It is just referencing other fields where the problem exists.