Results 1 to 4 of 4

Color Updated Text

Threaded View

  1. #1
    Registered User
    Join Date
    04-12-2016
    Location
    Oklahoma, USA
    MS-Off Ver
    Office 2007-2010
    Posts
    30

    Color Updated Text

    Is there a macro that can color the specific text in a cell that has been updated? Currently, I am using some conditional formatting as a temporary solution, but it colors all of the text in a cell if a change is detected.

    I plan on having another macro that will color all of the text in the sheet black after I have reviewed the changes.

    This proposed method is similar to the "track changes" feature in Excel, but I would like something that visually points out the specific text.

    See the attached file for an example of what I would like the macro to do. Column B shows the initial text in the cells and column C shows what the text color in these cells should look like after updates are made by the user.

    Any thoughts?
    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. Updated formulas obscure the text
    By turtle054 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-18-2015, 06:25 AM
  2. Cell color has to change for all updated cells on daily basis
    By ajaypal.sp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2015, 11:05 AM
  3. Replies: 4
    Last Post: 12-29-2013, 11:41 PM
  4. Replies: 1
    Last Post: 04-29-2013, 05:25 PM
  5. Replies: 0
    Last Post: 09-26-2012, 01:08 PM
  6. Replies: 0
    Last Post: 02-16-2006, 12:00 AM
  7. change text color based on adjacent cell text color
    By matthewst in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-01-2005, 03:49 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