[Solved] Highlight duplicate text w/ conditional formatting

[marko2002]

Hello all, just started using OO again after having difficulties with other sheets, and in calc I'm trying to auto highlight duplicate text and though I can see formulas for numbers, etc, I can't see how to do this for text. I have names in column R that goes from R11:R8000 and would like for those names to be highlighted automatically if they appear more than once in that column, could someone please assist in doing this
Most appreciated.
Marko

[Villeroy]

Select R11:R8000 (plus any other columns to be formatted conditionally and notice the active cell. In the following I assume R11 being the active cell.
Condition #1, change "Value Is" to "Formula Is": COUNTIF($R$11:$R$8000;$R11)>1
Notice the absolute reference $R$11:$R$8000 and the mixed row reference $R11. Relative references are relative to the active cell, applied to the entire selection when you click OK. The formula calculates how often this row's value in R occurs in R11:R800 and if this count is bigger than 1 the formula returns True and applies the specified cell style.

[marko2002]

Thank you, perfect