Highlight Cell, Only If Special Character Appears Twice In Same Cell

[indi visual]

I am looking for assistance with conditional format highlighting all cells in a column, but only if in that cell the character "(" appears twice.


If it only appears once in that cell (or more than twice), then do nothing.

 

[xld]

Use conditional formatting with a formula of


=(LEN(A2)-SUBSTITUTE(A2,"(",""))=2


and format as required

 

[indi visual]

Actually, I believe the code I am looking for would find two instances of the parentheses "(", regardless if they are back to back"((" beside each other or not "(" text text "(".


I would like to find two instances of the specified character and highlight that cell (regardless of where they appear in that particular cell).


If the formula you provided should still do this I apologize, I'm just not sure why I wasn't able to get it tip top when I tried the formula above.

 

[indi visual]

Never mind on that question xld, I found another way to do the same thing, and thank you for your help.