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?