There are no excel function for changing fonts or colors except the
conditional formating. In VBA youhavve to select a cell or range and then
change the Interior.colorindex or font.colorindex. Below is a macro that I
gort using the Learn Macro to get an example of these statements.

With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
Selection.Font.ColorIndex = 3


"jimmy" wrote:

Which function is for changing the font color? and what is the color index?

Thanks