Re: how to highlight duplicate text in columns?

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 <[email protected]>
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 <[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 [email protected]://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