Conditional Formatting to find duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
It should be

=COUNTIF (L:L,L2)>1

no quotes

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Does the L2 have the dollar signs around it like $L$2? If so, remove
them from the CF formula and then copy.

Does that help?

Steve
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Conditional Formatting 1
Excel Named Ranges and Conditional Format 3
Copy Conditional Formatting down rows 5
Excel Highlighting duplicates 0
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
How do I copy conditional formatting only? 5
conditional formatting in Excel 2007 1
Conditional Format - Formula 9

Back
Top