Saturday, February 23, 2013

yogi_WorkAround For Highlighting Double Entries In A Column

                                          Google Spreadsheet   Post  #1042
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Feb 23, 2013

                                                 UPDATED (added Sheet2) on Mar-10-2013

user Daniel Berling said:(!mydiscussions/docs/qKKDQzukQLU)
highlight double entries
Hi folks,

I have several spreadsheets which are used by many people. Basically we are putting a numbers in one row and in the next one we report a problem. Sometimes it happens that numbers are equal. In this case I want to highlight the cell with another color as a warning showing that there is already an entry with this number. In excel it works quite well but is it also working in google spreadsheets?

Any hint would be helpful.

following is a solution to the problem