5 Replies Latest reply on Mar 30, 2016 12:12 AM by HammerOz

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

    tomperr

      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.