Interior Cell Colour - Conditional Formatting

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.

http://www.cpearson.com/excel/CFColors.htm

Tim

"michael.a7" <[email protected]> wrote in message
news:[email protected]...
>
> 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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>