Highlight partly the same content

New Contributor



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!


3 Replies

@bbbettina Try Conditional Formatting with this rule:




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?