See Chip Pearson's site for info and code.

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

Or Bob Phillips' site

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


Gord Dibben MS Excel MVP

On Thu, 8 Jan 2009 15:52:26 -0600, "David Benson" wrote:

Is there a way to determine the conditional format that is displayed in a
cell?

I want a VB script to count all of the cells in a range that have particular
format. I would like to have cells included in the count whether the format
is "hard-wired" (fixed format), or whether the format is set by conditional
formatting.

Say I want to count the cells with a green fill. I want the count to
include cells that are permanently formatted with a green fill, as well as
cells whose current conditions result in a green fill being applied as a
result of conditional format.

Anyone have an leads on how to determine what format is currently displayed
in a conditionally formatted cell?


-- David