colourindex will do that


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If mycell.Value = whatever Then colourindex = 3
End Sub

would change the cell to red if true

"Stan Halls" wrote:

is it possable to change the cell colour / text depending on the value of the
cell.... using VBE rather than conditional formatting