Interior Cell Colour - Conditional Formatting

[michael.a7]

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

 

[Tim Williams]

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

Tim

 

[Guest]

The easiest way is to replicate the same formula that the cell uses for its
conditional formatting.

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)