Forcing Excel to retain red text?

[Sigi Rindler]

I need an MS Word or Excel guru using Office 2003. I need to insert text in
an existing MS Word or Excel job. The customer wants me to type every change
in red color.
Is there a setting that allows me to type text in the desired color only
without having to click the Font Color a million times?
What's the best solution if Word or Excel doesn't offer this function?

Any hint is appreciated.

Thanks,
Murgi

 

[Guest]

The following macro will locate all the empty cells in a Selected region and
change the font color to red. It will not change cells that are not empty:

Sub redify()
Dim r, rr As Range

For Each r In Selection
If IsEmpty(r.Value) Then
If rr Is Nothing Then
Set rr = r
Else
Set rr = Union(rr, r)
End If
End If
Next

If rr Is Nothing Then
Else
rr.Font.ColorIndex = 3
End If
End Sub

1. enter the macro
2. select cells in some region
3. run the macro
4. any material typed into the empty cells in the region will be in red

 

[Pete_UK]

In Word you can track changes - go to Tools | Track Changes | Highlight
Changes. Anything you subsequently type in will appear in red. I'm not
sure if you can change the colour.

Hope this helps.

Pete

 

[Sigi Rindler]

The following macro will locate all the empty cells in a Selected region
and
change the font color to red. It will not change cells that are not
empty:

Sub redify()
Dim r, rr As Range... snipped.

Thanks a lot for taking all the effort, but will I be able to to type in RED
in the cells that show "black" text?