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