What is the syntax to format a cell?

Range(“<cell reference>”).Font.Bold=<true or false>
Range(“<cell reference>”).Font.Underline=<true or false>
Range(“<cell reference>”).Font.Color=<rgb color>
‘examples
Range(“A1”).Font.Bold=True
Range(“A1”).Font.Underline=true
Range(“A1”).Font.Color=rgbNavy

 

Advertisements