9 Replies Latest reply on Mar 23, 2016 7:33 AM by user19752

    conditional formatting to make a container change color


      I have a container where I put images in.


      I want the container to turn red if I did not bring in a filename that contains the record number.


      For example


      I am currently in record number 125


      if I added 125b.jpg to container nothing happens

      if I added 125abc.jpg to container nothing happens

      if I added 124a.jpg to container the container turns red


      I have been trying conditional formatting but I am quite lost I think I need a formula but not sure how to word it...


      something like

      IF Get ( RecordNumber ) is not in filename then turn red

      Thanks guys first timer here!