Clearing Recently Used Font Colors

[cromei]

How do I clear the recently used font colors in my workbook? I can close it and restart my PC but the colors are still there. Any ideas? I have tried looking for an answer everywhere. I'm willing to use VBA code if I have to!! Help please!

[xladept]

Hi cromei,

Is there a way to tell whether the font colors were used recently?

Welcome to the Forum

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic