I have a report that we use for audi-trail purpouses, I am trying to figure out a way so that, if a field brings up certain text, it would highlight the line in red. So far i've had not luck. An example of what I thought should work is below, there are 2 select experts above the formula but removing them has no effect.

 

It needs to have wildcards to pick up a word within a specific line.

 

 

If I use the above, it says "a boolean is required here."

 

Any help would be greatly appreciated.

 

Thank you for the reply.

 

The problem is, highlight expert doesn't allow wildcards, (so it picks up a line with a word in, then highlights all of it) - Or atleast, I don't think it does.

 

This is why i'm trying a workaround formula.

 

Thanks,