Re: how to highlight duplicate text in columns?
Bruce Hohl via gnumeric-list <[email protected]>
| Newsgroups | gmane.comp.gnome.apps.gnumeric |
|---|---|
| Message-ID | <CALgJ8_wHP5Pb9ezfg8oHDsCLkB0uko2GycRnatVyge+0Djo2bQ@mail.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 <[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] > https://mail.gnome.org/mailman/listinfo/gnumeric-list > > _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list