+ Reply to Thread
Results 1 to 6 of 6

assistance for code that highlights cell difference

  1. 03-15-2017, 06:10 AM #1
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,176

    assistance for code that highlights cell difference

    Hi All

    I found the below code and need assistance to edit it to allow for the differences to be highlighted. can someone please assist.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 03-15-2017, 06:43 AM #2
    mgs73
    mgs73 is offline
    Valued Forum Contributor
    Join Date
    11-26-2012
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    419

    Re: assistance for code that highlights cell difference

    The code can be simplified a bit - try this (it highlights the cells in Sheet1 that are different by colouring them red)
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 03-15-2017, 06:44 AM #3
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,176

    Re: assistance for code that highlights cell difference

    Something like this?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 03-15-2017, 06:46 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,176

    Re: assistance for code that highlights cell difference

    Hi Mgs73

    That is absolutely fantastic. Thanks
    Reply With QuoteRegister To Reply
  5. 03-15-2017, 06:47 AM #5
    mgs73
    mgs73 is offline
    Valued Forum Contributor
    Join Date
    11-26-2012
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    419

    Re: assistance for code that highlights cell difference

    My pleasure.
    Reply With QuoteRegister To Reply
  6. 03-15-2017, 06:48 AM #6
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,176

    Re: assistance for code that highlights cell difference

    Just for interest sake, how would one fix the code with my original enquiry.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Code Check Please, Highlights based of values
    By Fawkes_ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2017, 05:16 PM
  2. [SOLVED] VBA code assistance with splitting of text in a cell.
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-21-2016, 05:11 AM
  3. [SOLVED] VBA code assistance with saving all worksheets except 4 as PDF with cell value as name
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-12-2016, 02:32 PM
  4. Code that highlights a row
    By reignkystar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2013, 09:55 PM
  5. spreadsheet code that highlights the row a cell is in and then the 3 rows bellow it?
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2012, 07:51 AM
  6. How to change existing code that highlights duplicates?
    By simonwilliams in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2009, 10:47 AM
  7. formula assistance - percentage difference
    By Dave in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-24-2006, 11:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1