conditional formatting......

I am looking for the easiest way to create a conditional formatting
formula for roughly 1000 rows, and 12 columns. What I want is if any
values are an exact duplicate to highlight all cells that are a match.
Im sorry if I didn't explain, well enough if you have any questions
please let me know.

Thanks for your help


---
Message posted from http://www.ExcelForum.com/

Try this page of Chip Pearson's

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

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"djackson " wrote in message
...
I am looking for the easiest way to create a conditional formatting
formula for roughly 1000 rows, and 12 columns. What I want is if any
values are an exact duplicate to highlight all cells that are a match.
Im sorry if I didn't explain, well enough if you have any questions
please let me know.

Thanks for your help


---
Message posted from http://www.ExcelForum.com/