font color changes

[Guest]

I would like to make some formatting in my excel file volatile.

if i make a change to a cell i would like the font colour to change to red.

is this possible?

any help appreciated.

ellebelle

 

[Dave Peterson]

Maybe...

You could use a worksheet_change event that looks for changes to your
worksheet. But you can fool this just by selecting a cell, hitting F2 and then
enter. Excel knows you reentered the value, but doesn't know that you didn't
really change it.

If you want to try...

rightclick on the worksheet tab that should have this behavior and select view
code. Then paste this into the code window that just opened.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Font.ColorIndex = 3
End Sub

One more question. When do you want to reset your cells back to black. If I
were doing something like this, I do that part manually--then I could keep the
font red for as long as I needed.

And remember that if you have cells that are Blue, this'll change 'em to Red.

 

[Guest]

Thank you! This has answered my question extremely well.

ellebelle