Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi anyone,
recently i put all worksheet formula into vba. Application now runs quite fast except for checking each cell having conditional formula to make null, zero-values and cells having the same value as the cell above invisible by using backgroundcolor as fontcolor. Changing the color within vba-code itself is not the problem. But I will loose information about regular cell-color once I change FontColor. In the next run it has to be changed back to regular color. I wonder, where microsoft stores the "regular" coloring of a cell since the conditional formula only knows the conditional color. regards willi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |