Conditional format row based on multiple criteria

Hi,

I have conditional format rule to highlight rows if two criteria are present, these are TCN****** (6 digit number), and A********** (10 digit number).

My current formula is
=COUNTIF($L5, "TCN* A**********")

This works fine if the criteria is found as TCN first and A* second, but if they are the other way around or other data in between then it doesn't highlight.

What would the formula be to highlight the rows if the criteria is in any order within the cell?

Also tried
=COUNTIF($L5,"TCN*")+COUNTIF($L5, "A*") but returns incorrect results

Thanks, used the first one and it seems to work fine.

I wasn't a million miles away I suppose

You are welcome.

In fact, you were very close.

Do not forget to mark this thread as solved.