Page 1 of 1
[Solved] Highlight duplicate text w/ conditional formatting
Posted: Fri Jan 03, 2020 10:35 am
by 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
Re: Another conditional formatting question!
Posted: Fri Jan 03, 2020 2:05 pm
by 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.
Re: Another conditional formatting question!
Posted: Fri Jan 03, 2020 7:58 pm
by marko2002
Thank you, perfect