Conditional Formatting

[Thompyt]

How can I have the Conditional formatting combined for the following?



"AO Deferred", "CCB Deferred"' "GO Deferred"

I want them all to be bold Red lettering. I have made three different rules for each to reflect the formatting (Bold Red Letters). Is there a way to combine these into one rule?

I have tried: Expression is equal to "AO Deferred" Or "CCB Deferred" Or "GO Deferred" It does not work.

Is there a way to put a text wildcard symbol in it? Like: Expression is equal to * & "Deferred" Note I have tried this but it doesn't work.

I do not want to have 3 different rules for each status. Suggestions?

Thanks

[June7]

Well, that is not a complete expression for rule.

[fieldname] = "AO Deferred" Or [fieldname] = "CCB Deferred" Or [fieldname] = "GO Deferred"

[fieldname] LIKE "*Deferred"

[Thompyt]

June7,
I tried the following:
Status LIKE "*Approved" in the Conditionl Formatting. The is the Conditional Formatting when you select the Forms control and right click, then select "Conditional Formatting. I see where you are going with this, but I am thinking this is for VBA?

I tried "*Approved" also = nogo

[June7]

My suggestion was for Conditional Formatting dialog. I tested both OR operator and LIKE *.

Note [] for field name.

[Thompyt]

June7,
I tried it both ways in two different styles. The [Status] field is a switch code in the query. (Status: Switch(GO..........)

Below is the outcome:

[June7]

Need to use Expression Is.

[Thompyt]

Duh. I should have known better. It all works now! Thanks June7!!