Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Click to expand...
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting and VBA 4
How do I Copy data dynamically to a calculated cell 1
Conditional Formatting macro: simple, but doesn't work 6
Check for the existence of conditional formatting 4
the value of a condition in a conditional format 2
Excel Macro to automatically go to the right of the last colored cell 0
Conditional Formatting with VBA 4
Conditional Formatting Formula propogating incorrectly 2

Back
Top