conditional formatting question

Debug.Print cell.Interior.ColoriIndex

does not return the color of a cell using conditional formatting. it
retunes -4142.

how do you return the cell colorindex of a conditionally formatted cell?

--


Gary

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:[email protected]...
> Debug.Print cell.Interior.ColoriIndex
>
> does not return the color of a cell using conditional formatting. it
> retunes -4142.
>
> how do you return the cell colorindex of a conditionally formatted cell?
>
> --
>
>
> Gary
>
>
>

ok, thanks, it's not that big of a deal, i'll work around it. just figured if a
cell had a background, it would be returned with colorindex.

--


Gary


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> Difficult. See http://www.xldynamic.com/source/xld.CFConditions.html
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "Gary Keramidas" <GKeramidasATmsn.com> wrote in message
> news:[email protected]...
>> Debug.Print cell.Interior.ColoriIndex
>>
>> does not return the color of a cell using conditional formatting. it
>> retunes -4142.
>>
>> how do you return the cell colorindex of a conditionally formatted cell?
>>
>> --
>>
>>
>> Gary
>>
>>
>>
>
>

No because the cell doesn't have that background, it is format. Just as a
cell with a format of 0.00 might show a value of 2.66, but really contain a
value of 2.67234. It is only presentation.

You could always check that the cell satisfies the condition stipulated in
the CF.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:[email protected]...
> ok, thanks, it's not that big of a deal, i'll work around it. just figured
if a
> cell had a background, it would be returned with colorindex.
>
> --
>
>
> Gary
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > Difficult. See http://www.xldynamic.com/source/xld.CFConditions.html
> >
> > --
> >
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from the email address if mailing direct)
> >
> > "Gary Keramidas" <GKeramidasATmsn.com> wrote in message
> > news:[email protected]...
> >> Debug.Print cell.Interior.ColoriIndex
> >>
> >> does not return the color of a cell using conditional formatting. it
> >> retunes -4142.
> >>
> >> how do you return the cell colorindex of a conditionally formatted
cell?
> >>
> >> --
> >>
> >>
> >> Gary
> >>
> >>
> >>
> >
> >
>
>

Hi Gary,
a bit late, but since you sprecifically mentioned -4142 as a color
and I don't see any specific response to that ...

it is the value for xlColorIndexNone
which is NOT the same as white for interior
nor is it specifically black for text.

Since it is a default, programming might actually disregard the
value and work perfectly well.

See http://www.mvps.org/dmcritchie/excel/colors.htm#macros

since the topic was conditional formatting you may find other related
material not already mentioned in this thread or on Bob's page at
http://www.mvps.org/dmcritchie/excel/condfmt.htm
also possibly
http://www.mvps.org/dmcritchie/excel/xl2html.htm

since this is an old thread (1 1/2 weeks) the complete thread can be reviewed at
http://google.com/groups?threadm=eW3...TNGP12.phx.gbl
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Gary Keramidas" <GKeramidasATmsn.com> wrote in message news:[email protected]...
> Debug.Print cell.Interior.ColoriIndex
>
> does not return the color of a cell using conditional formatting. it
> returns -4142.
>
> how do you return the cell colorindex of a conditionally formatted cell?
>
> --
>
>
> Gary
>
>
>