Hi Simon,

Well you were close. Here's what I figured out:

Operators are (as unlikely as it seems) numbered as they appear in the conditional formatting dialog:

1 = between
2 = not between
3= equal to
4= not equal to
5= greater than
6= less than
7= greater than or equal to
8= less than or equal to

Colours, well good luck. 3 _is_ red...

The vernacular is what you're looking for however:

[VBA]

Option Explicit
Sub Colour()
Dim myOp As Long
Dim myCell As Range
Set myCell = Range("A6")
myOp = myCell.FormatConditions(1).Interior.ColorIndex
If myOp = 3 Then
MsgBox ("Yup. It's red.")

End If
Set myCell = Nothing

End Sub
Sub Op()
Dim myOp As Long
Dim myCell As Range
Set myCell = Range("A6")
myOp = myCell.FormatConditions(1).Operator
Select Case myOp
Case Is = 1
MsgBox ("Between")
Case Is = 2
MsgBox ("Not between")
Case Is = 3
MsgBox ("Equal to")
Case Is = 4
MsgBox ("Not equal to")
Case Is = 5
MsgBox ("Greater than")
Case Is = 6
MsgBox ("Less than")
Case Is = 7
MsgBox ("Greater than or equal to")
Case Is = 8
MsgBox ("Less than or equal to")
Case Else

End Select
Set myCell = Nothing
End Sub

[/VBA]