Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |