Results 1 to 14 of 14

Find & highlight rows using VBA

Threaded View

  1. #1
    Registered User
    Join Date
    01-30-2013
    Location
    India
    MS-Off Ver
    2013
    Posts
    56

    Find & highlight rows using VBA

    Hi Experts,

    I need to highlight duplicate rows based on 3 columns using VBA.

    This is what I am looking for.

    Compare the values in column B, F & H.
    Highlight the duplicate values in column F & H. Also highlight the newest value in "Green" in column L & M based on the date in column B. I've attached a sample spreadsheet.

    I tried using the conditional formatting with formula but my spreadsheet is freezing and lands in to recovery mode. The file has more than 10000 rows.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find All and highlight selected rows
    By amberle in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-06-2020, 08:45 AM
  2. Problem with macro that needs to find and highlight rows based on searching cells
    By mnk181 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2014, 12:24 PM
  3. Replies: 1
    Last Post: 02-17-2014, 03:17 PM
  4. Quick way to find and highlight multiple rows?
    By tnovak in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-14-2014, 01:09 PM
  5. Replies: 0
    Last Post: 11-12-2013, 04:56 PM
  6. Replies: 2
    Last Post: 06-27-2012, 12:27 PM
  7. [SOLVED] highlight/remove highlight of rows conditional on cellvalue
    By timtim89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2012, 07:14 AM

Tags for this Thread

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