+ Reply to Thread
Results 1 to 1 of 1

Identify different cells value within sheet

  1. #1
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Lightbulb Identify different cells value within sheet

    Hello Experts,

    Request you to help me tweak the code,

    The attached file identifies duplicate rows & highlight those rows.


    we have a different requirement where in we have to identify those cells of the row which are not same.
    for example row 1 & row 9 have different data and row 4 & row8 have different data

    so only those cells should be highlighted which have different values, for example Red color is highlighted

    Unique Identifier is Column A data, on the basis of this their respective cells should be checked.

    The sheet will have around 8 lakhs data & 200 columns to be compared.

    Please assist
    Attached Files Attached Files
    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Identify all rows in sheet 1 containing number from sheet 2 array
    By Grebox in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2017, 07:45 AM
  2. [SOLVED] Identify second to the Last Row that have value in a certain sheet
    By 23inzane10 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-07-2016, 10:05 PM
  3. [SOLVED] is there a way to identify via vba if an entire sheet is protected or just some cells
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-28-2014, 06:00 PM
  4. How to identify objects in a sheet?
    By MnO in forum Excel General
    Replies: 2
    Last Post: 03-23-2009, 09:50 AM
  5. Formula to identify the sheet name
    By heski in forum Excel General
    Replies: 3
    Last Post: 03-28-2007, 11:43 PM
  6. [SOLVED] VBA code to identify last row in a sheet
    By SharonP. in forum Excel General
    Replies: 4
    Last Post: 02-17-2006, 10:20 AM
  7. identify active sheet
    By mike allen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1