Re: how to highlight duplicate text in columns?

Let's say that A1:A10 is the region of interest.

Select A1 down to A10 so that A1 is the primary cell.
Then choose Format->Cells->Conditional Formatting
Click Edit Style and pick the Background Color Red, OK
Select as condition "Expression x evaluates to TRUE".
Enter as x: countif(A$1:A$10,A1)>1  and finish with tab
click "Add"
click "close"

Any cells with duplicate value in A1:A10 should now be highlighted in red.

Andreas


On 2018-07-01 06:13 AM, Bruce Hohl via gnumeric-list wrote:
> I don't really know if the conditional format feature can do that, but 
> you can use something like countif(A$1:A$10,A1) in another column to 
> determine which cells are duplicates (i.e. count > 1).  Then you could 
> use conditional formatting on the countif() column.
>
> On Sat, Jun 30, 2018 at 5:41 PM, bill <[email protected] 
> <mailto:[email protected]>> wrote:
>
>     Hi all,
>     I'm thinking this would fall under conditional formatting, but
>     have not been able to find the option i need in the program or
>     manual. I need to search a single column containing some 12,000
>     rows of text and highlight any duplicates without removing
>     anything. Any help much appreciated!
>     peace
>     bill
>
>     _______________________________________________
>     gnumeric-list mailing list
>     [email protected] <mailto:[email protected]>
>     https://mail.gnome.org/mailman/listinfo/gnumeric-list
>     <https://mail.gnome.org/mailman/listinfo/gnumeric-list>
>
>
>
>
> _______________________________________________
> gnumeric-list mailing list
> [email protected]
> https://mail.gnome.org/mailman/listinfo/gnumeric-list

_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list