Re: Conditional Formatting to find duplicates

It should be

=COUNTIF (L:L,L2)>1

no quotes

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Personal Assistant" <Personal Assistant@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:5DFB8214-4CA4-4FE6-A442-AF651D79EBEE@xxxxxxxxxxxxxxxx
I have followed directions from MS online help to use conditional
formatting
to find duplicates. However, when I "paste special" the formatting into
all
of the cells, the CF stays the same and does not change from cell to cell.
For example, I used the following formula:
="COUNTIF (L:L,L2)>1" but when I pasted this CF to all other cells, L2
remains absolute.
Is there help for me?


.

Relevant Pages

  • Re: How do I calculate time durations over numerous dates
    ... >> subtract them. ... >>> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Zero values displaying as "-"
    ... HTH ... (remove nothere from the email address if mailing direct) ... > Here is the formatting I'm currently using: ...
    (microsoft.public.excel.newusers)
  • Re: Averages of absolute values
    ... Bob Phillips ... (remove nothere from the email address if mailing direct) ... calculate the average of the absolute values. ...
    (microsoft.public.excel)
  • Re: sumif absolute values
    ... HTH ... (remove nothere from the email address if mailing direct) ... > Is there any way to embed an absolute value function within a sumif ...
    (microsoft.public.excel.misc)
  • Re: Naming a (date) constant
    ... i know its just a matter of formatting it, ... > "Bob Phillips" wrote in message ... >> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.worksheet.functions)