I would like to get the color of a cell that has a conditional format on it
(cell shading light green). How can I do that from Visual Basic? I've
looked at two cell objects, one conditionally formatted green, the other
not, to try to spot which object members differed. I did not find anything.

Thank you.

Jerry K

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

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jerry K" wrote in message
...
I would like to get the color of a cell that has a conditional format on it
(cell shading light green). How can I do that from Visual Basic? I've
looked at two cell objects, one conditionally formatted green, the other
not, to try to spot which object members differed. I did not find
anything.

Thank you.

Jerry K

Thank you. That is what I needed.
Jerry K

"Bob Phillips" wrote in message
...
See http://www.xldynamic.com/source/xld.CFConditions.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Jerry K" wrote in message
...
I would like to get the color of a cell that has a conditional format on
it (cell shading light green). How can I do that from Visual Basic?
I've looked at two cell objects, one conditionally formatted green, the
other not, to try to spot which object members differed. I did not find
anything.

Thank you.

Jerry K