macro to display formatting of an individual cell

This code will show you some of the information you can receive using a macro. There's lots more you can get, though..

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    MsgBox "Cell Width: " & ActiveCell.ColumnWidth & vbCrLf & _
            "Font Color: " & ActiveCell.Font.Color & vbCrLf & _
            "Font Style: " & ActiveCell.Font.FontStyle & vbCrLf & _
            "Font Name: " & ActiveCell.Font.Name & vbCrLf & _
            "Cell Height: " & ActiveCell.Height, vbOKOnly, "Cell Characteristics"
End Sub

If you paste that into any sheet's code window, whenever you select another cell it will pop-up a message box telling you those characteristics. Obviously that would get old in a "live" spreadsheet, so you would probably link the macro to a keyboard shortcut or button, rather than the Worksheet's SelectionChange event.