Highlight partly the same content

[bbbettina]

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!

[#2]

@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

[#3]

@Riny_van_Eekelen not working

[#4]

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