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

    conditional formatting to make a container change color

    sec

      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!