Hi

I need a macro that can search a word that appears most frequently in entire sheet and then gives a random colour to all related cells in which that word appears.

EXAMPLE

A1= Three Books
A2 = Seven Days
A3 = Longer Days
A4 = Day & Night

As the word "Days" appears two time (most than any other word), the Macro should search all cells contaning word "Days" and fill in a random colour in cells in which that word is found.

Thanks