ExcelBanter - How do I highlight duplicate data on a spreadsheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I highlight duplicate data on a spreadsheet? (https://www.excelbanter.com/excel-worksheet-functions/55992-how-do-i-highlight-duplicate-data-spreadsheet.html)

Grim72

How do I highlight duplicate data on a spreadsheet?

I have a column of data on an Excel spreadsheet that should be unique codes.
I want to highlight any cells that contain duplicated data. Any idea how to
do this?
--
Grim

Don Guillett

How do I highlight duplicate data on a spreadsheet?

use conditional formatting
formatconditional format
formula
=countif(d:d,d1)1
format as desired
apply to all desired cells

--
Don Guillett
SalesAid Software

"Grim72" wrote in message
...
I have a column of data on an Excel spreadsheet that should be unique
codes.
I want to highlight any cells that contain duplicated data. Any idea how
to
do this?
--
Grim

Gord Dibben

How do I highlight duplicate data on a spreadsheet?

See Chip Pearson's site for working with and highlighting duplicates.

http://www.cpearson.com/excel/duplic...tingDuplicates

Gord Dibben Excel MVP

On Thu, 17 Nov 2005 07:46:01 -0800, Grim72
wrote:

I have a column of data on an Excel spreadsheet that should be unique codes.
I want to highlight any cells that contain duplicated data. Any idea how to
do this?

All times are GMT +1. The time now is 10:42 AM.