Hello again Excel Masters. Here is my question for the day:
Let us say I have 3 columns of data:
Column1:
Cat
Dog
Bird
Cat
Column2:
Horse
Dog
Monkey
Cat
Column3:
Bird
Dog
Monkey
Cat
How can I highlight or mark the cells that have repeat items. (e.g. All cells with 'Cat' would have a grey background, all cells with 'Dog' would have a green background.)
Using this example is the best way to describe my problem.
Thanks for the assistance.
Let us say I have 3 columns of data:
Column1:
Cat
Dog
Bird
Cat
Column2:
Horse
Dog
Monkey
Cat
Column3:
Bird
Dog
Monkey
Cat
How can I highlight or mark the cells that have repeat items. (e.g. All cells with 'Cat' would have a grey background, all cells with 'Dog' would have a green background.)
Using this example is the best way to describe my problem.
Thanks for the assistance.