Automaticly Highlight duplicate values in a column row

[MiRaDoR]

Hi, I was wondering...
Does Calc provide the same "Conditional Formatting" possibilities found in Excel? For example, I would like to highlight all cells that have duplicate values in a column row? I tried to google this, and threading this forum didn't do it for me.
Example:

Is there an easy way, like this Excel one in Open Office Calc?

[FJCC]

Select all of the cells you want to affect and notice which cell the cursor ends up in. That will probably be the first or last cell in the selection. Let's say you highlighted A1:A100 and the cursor is in A100. In the Format -> Conditional Formatting dialog, set the Formula Is to

Code: Select all

COUNTIF($A$1:$A$100; A100) > 1

and set the Style to whatever value you want.

[Villeroy]

COUNTIF($A$1:$A$100; A100) > 1

With more than one column selected you compare this row's value in column A:

Code: Select all

COUNTIF($A$1:$A$100; $A100) > 1

In rare cases:

Code: Select all

COUNTIF($A$1:$A$100; A$100) > 1

(this column''s value in row 100)

[juntjoo]

can someone explain how to select cells in more than one sheet? Thanks.

[atxemtp]

I have 5 (E-I) columns and 171 Rows (2-172) that I need to insure that there are no duplicate values. If there are duplicate values I want to highlight the duplicate values. How do I do this? I am new to open office.

[mircea273]

I have selected my 2 columns that I wanted to compare, then I went to "Format->Conditional Formatting->Condition"
There I have selected cell value is "duplicate" "apply style" "Warning" to make the duplicated values red.