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
Example to change backcolor to red