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.
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...
IF Get ( RecordNumber ) is not in filename then turn red
Thanks guys first timer here!