Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Conditional Formatting w/out the CF Coding
I searched all over the community to see if I can find what I am looking for
but I either missed it or it isn't available. What I am trying to do is, with VB, copy an entire worksheet and then paste it back into the same worksheet BUT only the values and all formattings... except I want the conditional formats to actually be converted from conditional formatting to actual formatting. In other words, with the original uncopied data the conditional formats have formulae in it to do the coloring. When it is copied I want it to still have the coloring applied as it was/is but not actually have conditional formatting to color it. I've tried all sorts of ways with the pastespecial xlvalues/xlformats/etc. but nothing gets rid of the conditional formats and yet still keep the coloring. Is this possible? Thanks In Advance! Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy Conditional Formatting w/out the CF Coding | Excel Programming | |||
How do I copy conditional formatting only? | Excel Discussion (Misc queries) | |||
Conditional formatting: Colour coding | Excel Discussion (Misc queries) | |||
Copy Conditional Formatting | Excel Discussion (Misc queries) |