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?
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?