I have the following UDF that returns the interior cell colour value o
a cell:
Function InteriorColor(CellColor As Range)
Application.Volatile
InteriorColor = CellColor.Interior.ColorIndex
End Function

However, when I use it on a cell that has conditional formatting - an
the formatting is being applied - the result is not the interior colo
value of the conditional format.

Does anyone know of a UDF that will recognise when a cell ha
conditional formatting and give the interior cell colour if th
formatting is being applied?

Many Thanks

--
michael.a
-----------------------------------------------------------------------
michael.a7's Profile: http://www.excelforum.com/member.php...fo&userid=3302
View this thread: http://www.excelforum.com/showthread.php?threadid=53537