• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

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.
 
Use conditional formatting with a formula of


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


and format as required
 
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.
 
Back
Top