Conditional Formatting with Wild Card

[Front]

I am trying to use a wild card with the conditional formatting, but I cannot seem to get it to work.

This formula works, but it has to be an exact match and I want the option to have words in front or behind the keyword in cell AC30:

=AND(Y3=$AC$30,ISBLANK(P3))

So I changed it to the following to include wildcards:

=AND(Y3="*"&$AC$30&"*",ISBLANK(P3))

But that does not work at all. Do I have something wrong or cannot you not use wild cards with conditional formatting?

 

[Fluff]

How about

=AND(isnumber(search($AC$30,Y3)),ISBLANK(P3))

 

[Front]

That worked, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.