AnsweredAssumed Answered

conditional formatting to make a container change color

Question asked by sec on Mar 22, 2016
Latest reply on Mar 23, 2016 by user19752

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!