Highlight partly the same content

New Contributor

Hi!

 

I would like to highlight the cells in column C that have partly the same content as the cells in column A.

For example, highlight cell C1 in red if there is a cell in column A witch contents match / partially match C1.

Thanks in advance!

275016612_274548481495432_5473367123940980464_n.jpg

3 Replies

@bbbettina Try Conditional Formatting with this rule:

 

=SUM(IFERROR(FIND($A$1:$A$9,C1),0))>0

 

and apply it to $C$1:$C$19

@Riny_van_Eekelen not working

@bbbettina That's a bit vague! Can you show what you did?