Conditional Formatting

Topic

New Reply

Hi

I’m using conditional formatting on a report.
One of the fields: [Why] contains a phrase e.g “Rework:Wheel Damaged” or “Rework:Door dented”.
Using ” Expression Is “, what would be the syntax to highlite on the report where the phrase contains “Rework” ?

Reply | Quote

Replies

If Rework is always the first word you can use:
Left([Why],6)=”Rework”

If Rework is anywhere within [Why]
[Why] Like “*” & “Rework” & “*”

Reply | Quote

Thank you, it works great.

Reply | Quote