+ Reply to Thread
Results 1 to 2 of 2

Highlighting changes to a spreadsheet in a differing STYLE

  1. #1
    CLare
    Guest

    Highlighting changes to a spreadsheet in a differing STYLE

    Can anyone help with the following query:
    I am trying to highlight the data entered during a week in a different
    colour to the normal default black.
    I have added a new STYLE but that only allows application to a set range of
    cells, but i want to be able to overkey existing data as well as enter NEW
    data and all the amendments are in a new colour say RED
    I have looked at TRACK CHANGES too but this just adds a flag and doesnt
    really HIGHLIGHT the change
    Please help us sad people
    Thanks

  2. #2

    Re: Highlighting changes to a spreadsheet in a differing STYLE

    Press Alt + F11 to get to the Visual Basic Editor
    On the left hand side, find the file you're working on, and double
    click on ThisWorkbook
    Its code window will open up.
    Insert the following lines of code:

    Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
    Range)
    Target.Font.ColorIndex = 3
    End Sub

    Now, whenever you edit a cell, its font color will become red.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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