Conditional Formatting to highlight duplicates question

You may use conditional formatting with this formula

Suppose list is A1 to a10

Please Login or Register  to view this content.

Regards

Thanks for your response but I don't think that will solve the problem.

My spreadsheet has multiple columns - I want to highlight the entire row for all instances of records having more than one instance of a unique unique reference number.
Am I correct in thinking the formula will need to refer to the column containing the unique reference number?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Still you can use this
select all the data use this:

Please Login or Register  to view this content.

Also your 32028 & 17516 refer to more than one person

You may copy this formatting by format painter tool

Regards

Many thanks for your reply.
Sorry about errors.

When i format paint your example into my spreadsheet (which has columns extending to "Y") the highlighting is random. I wish to highlight the entire row where a "URN" in column A exists more than once.
Sorry if I am missing something simple here - my excel knowledge is pretty basic!
I have attached another example.

Select all the range and then copy the above formula in conditional formatting.
Conditional formatting + manage rules+ .....

It should work.

Regards

Does the attached help ?

The $ sign in the $a2 part is the trick

Originally Posted by mahju

=IF(COUNTIF($A$2:A2,A2)>1,TRUE,FALSE)

You can reduce that to:

=COUNTIF($A$2:A2,A2)>1

Try this...

First, delete all the formatting rules you have tried that failed.

Select the *entire* range A2:Y62 starting from cell A2.
Cell A2 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the Home tab>Styles>Conditional Formatting>
Manage rules>New rule>Use a formula to determine
which cells to format

Enter this formula in the box below:

=COUNTIF($A$2:$A$62,$A2)>1

Click the Format button
Select the desired style(s)
OK out

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.