http://www.cpearson.com/excel/CFColors.htm
Tim
"michael.a7" wrote in message
...
I have the following UDF that returns the interior cell colour value of
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 - and
the formatting is being applied - the result is not the interior color
value of the conditional format.
Does anyone know of a UDF that will recognise when a cell has
conditional formatting and give the interior cell colour if the
formatting is being applied?
Many Thanks.
--
michael.a7
------------------------------------------------------------------------
michael.a7's Profile: http://www.excelforum.com/member.php...o&userid=33027
View this thread: http://www.excelforum.com/showthread...hreadid=535376