Conditional Formatting - Checking Cell Colours

Hi,

I am trying to figure out a way to check the ColorIndex of cells in Excel.
I think the problem is that the ColorIndex of the cells in question is decided by conditional formatting

Basically there are red cells (ColorIndex 3) and green cells (ColorIndex 35), the Pattern is xlsolid.

I want to create an If statement a bit like this:

If cells(Row,Column).ColorIndex = 3 Then
.......
End If

I think because the colorindex is decided by Conditional Formatting it isnt picking up.

Any ideas?

Many thanks,

Alan