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

With toCel
.Value = fromCell.Valu
.Interior.ColorIndex = fromCell.Interior.ColorInde
.Interior.Pattern = fromCell.Interior.Patter
End Wit

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?

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?
.