Detect Conditional Format Fill Colour

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

Please Login or Register  to view this content.

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

hi, teekay, you can use conditional format formula and check your cells with it using VB. Interior.Colorindex does not catch conditional format colouring.

It's always helpful to provide a sample workbook in question.