First time here? Check out the FAQ!
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:
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)
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-07-10 23:38:55 +0200
Seen: 181 times
Last updated: Jul 11 '12