[ExcelVBA] Re: Formatting with Macro

 

Excel 2007 also Pastes the Conditional formatting not just the current format with the Paste Special Formats.... bummer (:-(
Steve

--- In ExcelVBA@yahoogroups.com, "Paul Vermeulen" <paul.vermeulen@...> wrote:
>
> Hi John
>
> Your scratchings are clear, so no worries. Not close to Excel, but try the following: Record a macro, and copy some cells with conditional formatting, then next to it, paste special as values only, then paste special again with formats only.
>
> Stop recording and see if conditional formatting is active in new range or not. Not sure if will work, but worth a try.
>
> Sent from my iPad
>
> On 13/04/2012, at 9:08 PM, "Dr John C Bullas" <john.bullas@...> wrote:
>
> > Is there anything in excel to do the equivalent of "paste value" for formats?
> >
> > To condense conditional formats just to their present cell format state?
> >
> > Any deprocation of the version of excel from say excel 2003 to 1995
> > that strips the logic off but leaves the cells formatted bold, grey,
> > underlined or whatever? Export out (save as with yes yes yes!) to
> > this version and open the slimmed down workbook resave to the later
> > version?
> >
> > The penscratchings of the worlds worst VB scripter
> >
> > Dr B
> >
> > On 13/04/2012, sspatriots <sspatriots@...> wrote:
> > > Hi,
> > >
> > > I have several worksheets in a workbook that currently have conditional
> > > formatting to shade adjacent cells in the range F2:J20001 if there value is
> > > less than a number in the adjacent cells in column B. For example, if cell
> > > H33 has the number 9.898 in it and B33 has the number 10, then I want H33
> > > shaded.
> > >
> > > I would use conditional formatting for this, however, I have a subsequent
> > > macro that copies these worksheets to another workbook and I don't want all
> > > the conditional formatting to go with it. I just want to copy the values and
> > > the formats to the new workbook. While I realize there is code out there
> > > that shells out to MS Word using HTML and then back to Excel, it is really
> > > slow. If I copy the conditional formatting to the new workbook, the file
> > > size is huge. Any help would be greatly appreciated.
> > >
> > >
> > > Thanks,
> > >
> > > Steve
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > ----------------------------------
> > > Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> > > here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
> > > ARCHIVES for EXCEL VBA.
> > >
> > > ----------------------------------
> > > Visit our ExcelVBA group home page for more info and support files:
> > > http://groups.yahoo.com/group/ExcelVBA
> > >
> > > ----------------------------------
> > > More free tutorials and resources available at:
> > > http://www.mousetrax.com
> > >
> > > ----------------------------------Yahoo! Groups Links
> > >
> > >
> > >
> > >
> >
> > --
> > Sent from my mobile device
> >
> > ===========================
> > http://uk.linkedin.com/in/drjohnbullas
> >
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (8)

Recent Activity:

• New Members 4

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___