Change default text color without reformatting the sheet.

[Monorail Central]

I have a premade worksheet that I want to send to others so they may add and
edit information. I need the text they type to appear in a pre-determined
color that I choose while the existing unchanged cell data remains black.
When they save it and send it back to me, I need to see the data they added
or edited in the new color. I don't need to protect the sheet (unless your
answer requires it).

Thank you in advance for your help!

 

[Gord Dibben]

You could add some event code that turns any added or edited cells to a
highlighted background or text color. The code below changes background
color but can be edited for font color.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo endit
Application.EnableEvents = False
Target.Interior.ColorIndex = 3 'change Bkgrd color to red
Target.Font.ColorIndex = 3 'change font color to red
endit:
Application.EnableEvents = True
End Sub

This is sheet event code. Right-click on the sheet tab and "View Code"

Copy/paste into that module, edit to remove either the Bkgrd color line or
font color line then Alt + q to return to the Excel window.


Gord Dibben MS Excel MVP

On Wed, 14 Jan 2009 15:31:00 -0800, Monorail Central <Monorail