Is it possible to apply conditional formatting to a field in a report if part of the string meets the condition?
I have a report that prints out a calculated field – Details – that is made up of a category grouping plus the various detail info associated with the category:
e.g. “Documents – Passport” or “Financial – Banking”. Occasionally one of the workers manages to circumvent the various checks put in place to control them and manages to leave the detail ( in these examples passport and banking) out in which case the query puts in the phrase “Not Recorded Properly”. In the original report, I have conditional formatting that looks for “Not Recorded Properly” and formats it in red and underlines it so the supervisor can see where the problems are.
On this new report, because of the newly combined fields, I need to search for a partial string rather than the whole string.e.g. “Documents – Not Recorded Properly” or “Banking – Not recorded Properly”. I’ve got as far as deciding that I need to use “Expression Is” in the conditional formatting dialogue, but don’t know how to construct the expression. I played around with the InStr function and looked at InStrRev but am stuck on how to feed the info to the function. 
Of course, if the pesky users would record things properly, I wouldn’t have to do this…
