LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Member
 
Posts: 89
Post Finding Duplicate Rows & Highlighting them

I have data in a worksheet that contains both numbers & text.

I want to find a formula or Macro that can search the entire sheet and ONLY highlight the rows that are duplicated. Not just the first cell, the whole row.

The data goes from Column A to Column M.

I don't want them deleted or moved - only highlighted.

Any/all assistance would be greatly appreciated.

Thank you
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding Duplicate Rows (Macro) Edwin Excel Discussion (Misc queries) 2 July 2nd 09 09:02 PM
Finding duplicate values and deleting both rows [email protected] Excel Programming 3 May 16th 07 10:28 AM
Finding Duplicate Rows Secret Squirrel Excel Discussion (Misc queries) 1 April 8th 07 05:49 AM
finding duplicate rows [email protected] Excel Worksheet Functions 1 June 16th 06 01:31 PM
Deleting/highlighting duplicate rows Sharon Excel Programming 4 November 13th 04 08:12 PM


All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"