You can learn: Formatting Cells Font with VBA, include Font Name, Font Style, Font Size, Underline, Font Color and Font Effects.

Returns a Font object that represents the font of the specified object. Syntax expression.Font expression A variable that represents a Range object. […]