Thanks for that post, I did not know before how to use "Expression x evaluate to True".
On Sun, Jul 1, 2018 at 3:58 PM, Andreas J. Guelzow <aguel...@pyrshep.ca> wrote: > 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 <bi...@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 >> >> > > > _______________________________________________ > gnumeric-list mailing > listgnumeric-list@gnome.orghttps://mail.gnome.org/mailman/listinfo/gnumeric-list > > > > _______________________________________________ > gnumeric-list mailing list > gnumeric-list@gnome.org > https://mail.gnome.org/mailman/listinfo/gnumeric-list > >
_______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
