What is the syntax to format number output?

 Format(<value>, "<formatting convention>")
'example - outputs 2
decimalNum = 2.31321
Msgbox Format(decimalNum, "0")

 

Advertisements

What is the syntax to change font color?

'method 1
Cells(<row number>, <column number>).Font.ColorIndex = <color index integer>

'method 2
Range(“<cell reference>”).Font.ColorIndex = <color index integer>
‘examples
Cells(2,4).Font.ColorIndex = 5
Range(“D2”).Font.ColorIndex = 2