highlight changes

  1. M

    How can I highlight cells that have been changes since "X" date ?

    Hello! I have a mega forecast that people update and I'd like to make it simple to see which cells have been updated (could be added as a new line or info deleted or changed in a cell). The model already has lots of conditional formatting indicating various things so it needs to work on-top of...
    • momentumons
    • Thread
    • conditional formatting excel conditional formatting highlight changes
    • Replies: 6
    • Forum: Excel Questions
  2. B

    Compare two lists

    Hi there! I am trying to do this way (https://www.excel-easy.com/examples/compare-two-lists.html) to compare in VBA but I can not get the same result as when I try it manually.
    • BrianAgBe
    • Thread
    • compare 2 tables excel 2016 highlight changes macro issue vba
    • Replies: 3
    • Forum: Excel Questions
  3. D

    Can I use conditional formatting to highlight where a cell has been changed (e.g. from N to Y)

    Hi all, I have an Excel spread sheet setup to display departmental compliance with certain criteria, and at the moment I have conditional formatting to show the cell as red when it contains "n" and green when it displays "y". What I would like to do is show also when a cell has been changed...
  4. C

    Sorting the unsorted

    All, Good morning, obviously looking for a bit of help here so I will try and be descriptive as possible. I have One Spreadsheet bringing in data from two different locations. In each of the linked spreadsheets There is a unique number in both documents ( a Construction Drawing number...
    • chutton
    • Thread
    • highlight changes link lists sort sorting and combine
    • Replies: 0
    • Forum: Excel Questions
  5. T

    Highlighting changes in cell *after* data input macro is run

    Hello All, I'm not an Excel genius by any means, and I know enough VBA to get me by. I have a quick question for you all and I hope it's an easy solution. I work for a marketing agency where technical savvy-ness is really limited. We analyze a lot of web page elements. I have a program that...
  6. Z

    Highlight cells using VBA

    Hi, I am running a macro to make some changes to certain cells in a spreadsheet (formula changes) Is there a code I can include within the macro so that all cells that change are also highlighted in yellow?
  7. J

    Compare 2 worksheets of same size and highlight changes in different colour

    I am completely new to VBA. I have 2 worksheets of the same size (about 4000 rows), cells containing either text, time or date data. I need to compare the new worksheet with the old and highlight anything that has changed on the new with a different colour. I currently do the exercise in...
  8. A

    automatically highlight modified cells

    Version Excel 2007 We distribute a report to many users. The users edit some of the cells and return the report. Question: How can we have the modified cells automatically highlight when edits are made? We want to be able to view all edited cells at a glance. Thank you for your help....!
  9. V

    Worksheet_Change to Highlight Changes

    I'm trying to find code (I can't write my own yet) that will highlight any cells that have been changed with fill color and bold font. I've searched around the forum and come up with the code below so far. It's not working - when I make a change to a cell and hit enter, it highlights and bolds...
  10. B

    track changes referencing multiple sheets

    I am trying to use the track changes option. I have a multi sheet workbook and want to track changes in different cells on each sheet. However I cannot figure out how to enter these references into the Where: option of highlight changes. I can select one sheets cells, as soon as I enter a second...

Watch MrExcel Video

Learn Excel - Pivot From Many Sheets: Podcast #1331

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top