Re: [ExcelVBA] Formatting with Macro

 

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@gmail.com> 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@yahoo.com> 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 (7)

Recent Activity:

• New Members 3

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

.

__,_._,___