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

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

The easiest way is to replicate the same formula that the cell uses for its
conditional formatting.
--
Gary''s Student


"michael.a7" wrote:


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

See http://www.xldynamic.com/source/xld.CFConditions.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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