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" wrote in message
...
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
...
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