The real reason for asking is that the conditions set the
interior.colorindex. When I check the cell to see what interior.colorindex
is used, it always returns -4142 (likely xlAutomatic). This seems like an
error to me. Since I can't count on the colorindex to tell what happened, I
tried to see if I could find out which condition hit, then check its
colorindex.

Is there another attribute that tells what color is displayed instead of
what the interior.colorindex has as a value. All in all, it seems like an
error in Excel / VBA.

Brad C.


On 6/10/06 11:25 PM, in article
, "KellTainer"
wrote:


There is no such method in VBA which allows you to do this. The only
things I found about conditional format is that you can get the
conditional formats of a cell by using the conditional formatting
collection eg. Sheet1.Range("A1").FormatConditions, But not which
format was used itself.

You might wanna see which conditional format is activated by listing
out the conditions in the excel spreadsheet itself, seeing which
condition gives true/false values. Or give each value a different
format. However, since you want to see it in VBA.. I do not believe you
can. Thats the only way I think you can debug it.