I have used the following section code to detect the fill colour of a range of cells.


If ActiveCell.Interior.ColorIndex = 3 Then red = red + 1
If ActiveCell.Interior.ColorIndex = 4 Then green = green + 1
This works fine if the fill colour is set in the normal way.

However, if the fill colour is set to red in the normal way but changes to green due to a "conditionlal format" all cells are detected as red.

Can anyone help to detect the colour as displayed, regardless of how achieved.

Thanks Teekay