Change Color Of Cell Text When Cell Info Is Changed

[ctsuhako]

I would like to be able to use a macro or some simple VB to do the following:

If the entered data in a cell is changed, I would like the changed data to be shown as red. This should apply to the entire workbook.

Is there a simple way of achieving this?

Thank you.

 

[HalfAce]

Well, yeah there is a simple way to do that. But, I'm sure all the other issues it brings up will be what you notice next.

To start with, here's what you've requested. (We'll deal with the rest as you bring them up.)
Go into your vb editor and double click on 'ThisWorkbook'. (Will put you inside the ThisWorkbook code module.)
Copy & paste this code in there:

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

And then hit AltQ to close the vb editor.

Now what ever value gets changed, or - (as currently written), entered in the workbook will turn red.

Does that help?

 

[ctsuhako]

Hello, HalfAce:

This works well, except for the following refinement:

1. Can I exclude blank cells from being subject to the color change, or better yet exclude certain cell ranges?

What I have is a very long pricing list and would like to user to be able to quickly see what prices have changed.

Thank you.

 

[HalfAce]

Oh yeah, absolutely.
Would you rather exclude certain range from this, or would you rather just specify the range(s) you want it to work in?

If you were to only want it to perform on the pricing list(s), what sheet(s)/range(s) would we be looking at?

 

[ctsuhako]

Hello, HalfAce:

It would make more sense to specify the range(s). It would only involve one sheet with multiple ranges. A basic example would be sufficient (I think). Thanks!