Forum Discussion
Solved
letter by letter comparison
Hi everyone, I need to compare the contents of a cell with a certain column. Let say we have a column with one character in each cell, I need excel to erase/delete (or change the filling color of) ...
I think I've done.. I hope so anyway.
Thank you Haytham,
I found no solution in the attached file, no formula in any cell.
Basically, we should have a column with text, and once we paste text in a certain defined cell, the same letters disappear from the column (or change cell filling color).
Thank you.
In fact, there is a formula in the worksheet, but it's hidden in a conditional formatting rule.
=IF(AND(COUNTIF(C:C,C1)>1,COUNTIF($C$1:C1,C1)=1),TRUE,FALSE)
It seems that this isn't what you want, I think I didn't understand your question well, so I'll try with another solution and refer back to you if I got it.
Regards