Conditional Formatting Exceeds 3 Conditions

[jereece]

In a report I have a "Priority" field that can have a potential of 24 codes. About 8 of them are considered high priority. These high priority codes all contain a "1" in them and I need to have a conditional format to highlight these red. So for example, some of my high priority codes are 1, I1a, I1b, O1a, O1b, etc. The common key is they all contain a 1.

I tried using field is equal to "*1*" in conditional formatting, but this does not work. I did a quick review on this forum, but did not find a solution.

An suggestions is appreciated.

Jim

 

[pbaldy]

You want an expression, and use Like instead of =.