I use a conditional format to change the interior colour of cells. the
conditional is the same for all the cells to which the conditional
format refers. I'd like to know the displayed colour of a cell to
which the conditional format is applied, from VBA code. the
"background" colour of the cell is available as
<cell.interior.colorindex
the conditional format color is available as
<cell.<conditionalformat(1).interior.colorinde x
but the displayed colour depends on whether
<cell.<conditionalformat(1).formula1
is true or false.

I'd rather not have to write an interpreter for what could be a
general expression.

thanks,
Eric