Re: how to highlight duplicate text in columns?

[Bruce Hohl <brucehohl gmail com>]

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 <billd post com> 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
gnumeric-list gnome org
https://mail.gnome.org/mailman/listinfo/gnumeric-list