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!

Outcomes