+ Reply to Thread
Results 1 to 2 of 2

Highlight data rows not matching calculations

  1. #1
    Forum Contributor
    Join Date
    01-20-2014
    Location
    Greece
    MS-Off Ver
    20 yr. old Excel 2002!
    Posts
    710

    Highlight data rows not matching calculations

    Hi
    Here is a tough one.

    A2:N10 performs calculations on DYNAMIC A20:H32. Dynamic because it may contain variable rows, it always starts on A20 though.

    What we ask is to highlight row or rows that do not match any of the calculations in A2:N10, in this case row 21.

    This probably needs 2 VBA macros that are sheet specific since similar data and calculations are in sheet 3 (not included here).

    One for sheet 1 taking into account ONLY calculations done in A2:N10 and NOT anywhere else in the sheet, and adressing data A20:H...
    and
    One for sheet 3 taking into account ONLY calculations done in A2:N12 and NOT anywhere else in the sheet, and adressing data A20:H...

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-20-2014
    Location
    Greece
    MS-Off Ver
    20 yr. old Excel 2002!
    Posts
    710

    Re: Highlight data rows not matching calculations

    Ok.
    I will make it a bit easier.
    I will highlight the range A20:H... before macro execution.
    This way, there should be only one macro that works on the highlighted range.

+ 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. Highlight Rows with matching conditions..
    By kundanlal in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-24-2015, 11:57 AM
  2. Replies: 4
    Last Post: 09-15-2014, 11:57 PM
  3. Replies: 0
    Last Post: 04-15-2014, 12:02 PM
  4. Matching Data between Files , Deleting Matching Rows
    By nem_vdoxx in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-20-2013, 11:00 AM
  5. Compare row and highlight matching data Macro
    By damdam in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-17-2013, 12:45 PM
  6. Highlight rows with matching ID#'s
    By rainbowforest in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-02-2011, 03:27 AM
  7. Compare 2 columns and highlight matching data
    By schueyisking in forum Excel General
    Replies: 3
    Last Post: 08-13-2009, 10:47 AM

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