AnsweredAssumed Answered

Conditional formatting on with "Formula is" does not trigger change

Question asked by tomperr on Mar 28, 2016
Latest reply on Mar 30, 2016 by HammerOz

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.