Change default text color without reformatting the sheet.
 

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!

Change default text color without reformatting the sheet.
 

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
wrote:

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!