'Highlight Partial Matches in a Single Column in Google Sheets

How can I highlight Partial matches in a single column of google sheets? some entries are the same but they have slight misspellings or some are in lowercase. How do you highlight these partial matches? thank you very much

Im hoping it would like this

google-sheets

Solution 1:^[1]

try:

=(INDEX(COUNTIF(REGEXREPLACE(A:A, "[^A-Za-z]+", ), 
                REGEXREPLACE(A1,  "[^A-Za-z]+", )))>1)*(A1<>"")

what this does is that regex will delete everything which is not A-Z or a-z

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	player0

'Highlight Partial Matches in a Single Column in Google Sheets

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]