+ Reply to Thread
Results 1 to 2 of 2

VBA to highlight change in formula in a row

  1. #1
    Registered User
    Join Date
    02-05-2020
    Location
    India
    MS-Off Ver
    O365
    Posts
    5

    VBA to highlight change in formula in a row

    Hi there,

    I am trying to develop a code which would highlight row differences in Activeworksheet using loop. The rows range would be dynamic in every worksheet. Also, in some of the worksheets, there would be text in column A while in other worksheets in column D (so headings for each would again be in dynamic columns). I want to use a code wherein macro would search for first cell containing formula in the first row and then comparing rest of the row with the same formula. Same process would be repeated for remaining rows containing data. Would appreciate if someone can help me out.

    Thanks,

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: VBA to highlight change in formula in a row

    Read How to Attach Your Sample Workbook at the top of this page and comply.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. change mark (or highlight) color
    By tsotzo in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-17-2017, 08:44 AM
  2. Highlight change in cells
    By madhatter40 in forum Excel General
    Replies: 2
    Last Post: 05-16-2014, 06:23 AM
  3. [SOLVED] VBA Highlight Row On Cell Value Change
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-21-2013, 07:02 AM
  4. [SOLVED] Formula to highlight cell (or change font color) when condition is met
    By Maezee in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2013, 04:17 PM
  5. Highlight Change in Row
    By Cecil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2009, 06:00 PM
  6. [SOLVED] Highlight entire document and try to change font - won't change.
    By murzy03 in forum Excel General
    Replies: 1
    Last Post: 05-08-2006, 02:05 PM
  7. [SOLVED] change color to highlight changes
    By Nick Cumberbatch in forum Excel General
    Replies: 0
    Last Post: 05-06-2006, 04:30 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