yogi_Workaround For Highlighting All Cells in Column B That Occur More than Once

                                           Google Spreadsheet   Post  #835
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Oct 27, 2012
user Martin Cahill said: (http://productforums.google.com/forum/#!category-topic/docs/how-do-i/CjfiAKDjh2Q)
Duplicate cells
Im using google docs spreadsheet.

In coloumn B

If a duplicate value is entered  anywhere in the coloumn I would like both cells to be highlighted.

Can this be done?

Martin
----------------------------------------------------------------------------------------------------------
following is a Workaround solution to the problem