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