Mar 09 2022 05:50 AM
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!
Mar 09 2022 06:23 AM - edited Mar 09 2022 06:24 AM
@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
Mar 10 2022 03:51 AM
@bbbettina That's a bit vague! Can you show what you did?