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" <(E-Mail Removed)> wrote in message
news:471e3953$0$497$(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:471e3953$0$497$(E-Mail Removed)...
>>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
>>
>
>