How to write a macro code for specific font color?

[kingston_123]

Specific font color is Tan, Background 2, Darker 50%

I want a VBA macro code for this.

[oeldere]

You can use the macro recorder to get the code.

View => macro => record macro.

[kingston_123]

I got it:

Sub Macro2()
'
' Macro2 Macro
'
' Keyboard Shortcut: Ctrl+Shift+G
'
ActiveCell.Select
With Selection.Font
.Color = -11236716
.TintAndShade = 0
End With
End Sub

[oeldere]

Glad I could help.

Thanks for marking the question solved.

You can add reputation by clicking on the star * add reputation.

Please add your code between # according to the forum rules.