2 colors in formula

[JAZZWAKEFOREST]

I have created the formula below, but I would like to add color to the word GO and STOP. GO will be Green and Stop will be red. How do I do that? HELP

ActiveCell.FormulaR1C1 = "=IF(RC[1]=RC[-1],""GO"",""STOP"")"

 

[Andrew Poulsom]

thank you!!! ITS WORKING...how can i add bold now?

The easiest way to find out is to record a macro while doing it manually. But try:

Range("I2").Select 
    With ActiveCell 
        .FormulaR1C1 = "=IF(RC[1]=RC[-1],""GO"",""STOP"")" 
        .FormatConditions.Delete 
        .FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, Formula1:="=""GO""" 
        With .FormatConditions(1)
            .Font.ColorIndex = 10 
            .Font.Bold = True
        End With
        .FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, Formula1:="=""STOP""" 
        With .FormatConditions(2)
            .Font.ColorIndex = 3 
            .Font.Bold = True
        End With
        .AutoFill Destination:=Range("I2:I9000"), Type:=xlFillDefault 
    End With 
    Range("I4").Select