Hi! I need to highlight cells with "cat" and "3" (in all interpretations: 13, 23, 31, 32, 33 etc.) in yellow

I used this formula in conditional formatting:

=IF(SEARCH("3";LEFT($A1;FIND(" ";$A1)-1);1)>0  

But it doesn't work.

How to properly format cells?

Thank you!

https://stackoverflow.com/questions/66155773/hi-i-need-to-highlight-cells-with-cat-and-3-in-all-interpretations-13-23 February 11, 2021 at 09:33PM