Hi
not really a chance to prevent this. The conditional
format colors are NOT reflected in the colorindex
property. This property ALWAYS shows the default color
index.


-----Original Message-----
I am using a macro that "pulls" the formatting from a
cell. The code is:

With toCell
.Value = fromCell.Value
.Interior.ColorIndex =
fromCell.Interior.ColorIndex
.Interior.Pattern = fromCell.Interior.Pattern
End With

However, the patterns of the "fromCell" are assigned
using conditional formatting. While the coloring is
visible right on the "fromCell", when the macro pulls the
formatting, it often reverts to the formatting done BEFORE
the condional formatting is applied. Any suggestions?
.