Business Applications
Hello.
Would anyone know how to use conditional format when the same word appears twice in one cell?
In the example below, A1:A4
A1 apple
A2 apple, banana
A3 apple, apple, banana
A4 apple, apple
one cells A3 and A4 should be highlighted using conditional format