Excel – How to force Excel to always type purple text

microsoft excelmicrosoft-excel-2010

I'm making changes to a large Excel worksheet, and every change I make needs to be in purple text. Right now, I'm typing the change and then clicking purple text.

Is there a way to force Excel to always type purple? Or is there a keyboard shortcut I can use to apply the purple text without taking my hands off the keyboard?

I'm not asking how to change the keyboard shortcuts. I need to end up with a clean sheet (no Track Changes still visible) with the cells that I've changed in purple text. I'm not changing every cell, just about 30% of them.

Best Answer

If VBA is a valid solution: You can use the Change event to automatically colorize your cell if you change values.

Example to change text color to purple

Private Sub Worksheet_Change(ByVal Target As Range)
    Target.Font.ColorIndex = 7
End Sub

Example to change backcolor to red

Private Sub Worksheet_Change(ByVal Target As Range)
    Target.Interior.Color = RGB(255, 0, 0)
End Sub
Related Question