Not sure what I am doing wrong, but here is what I have in the macro so far. STOP and GO do come up, but not in the colors.
End With
Range("I2").Select
ActiveCell.FormulaR1C1 = "=IF(RC[1]=RC[-1],""GO"",""STOP"")"
Range("I2").Select
Selection.AutoFill Destination:=Range("I2:I9000"), Type:=xlFillDefault
Range("I2:I9000").Select
Range("I4").Select
With ActiveCell
.FormulaR1C1 = "=IF(RC[1]=RC[-1],""GO"",""STOP"")"
.FormatConditions.Delete
.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, Formula1:="=""GO"""
.FormatConditions(1).Font.ColorIndex = 10
.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, Formula1:="=""STOP"""
.FormatConditions(2).Font.ColorIndex = 3
End With