Stop Duplicate Cells

answered 2012-07-11 08:59:35 +0200

JohnSUN
2338 ● 2 ● 23 ● 36
http://wmstrong.ru/

updated 2012-07-11 09:02:49 +0200

Of course, you can do it.

Select a sufficiently large range in the right column (for example A2:A500).

Apply a conditional formatting to the selected range:

1. With the formula

   COUNTIF($[First cell]:[Current cell];[Current cell])>1

or 2. With special condition "duplicated values"

(IMHO, this conditional formatting not will be saved in the final document - when you open the table you will need to redefine it)