Re: [ExcelVBA] Formatting with Macro

 

Heya,

What about setting up the conditional formatting in code. Deleting it and adding it and running that after copying the worksheet.

HTH
Lisa

Sent: Fri, Apr 13, 2012 12:16 pm
Subject: [ExcelVBA] Formatting with Macro

Hi,
I have several worksheets in a workbook that currently have conditional
ormatting to shade adjacent cells in the range F2:J20001 if there value is less
han a number in the adjacent cells in column B. For example, if cell H33 has
he 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
hat copies these worksheets to another workbook and I don't want all the
onditional formatting to go with it. I just want to copy the values and the
ormats to the new workbook. While I realize there is code out there that shells
ut to MS Word using HTML and then back to Excel, it is really slow. If I copy
he conditional formatting to the new workbook, the file size is huge. Any help
ould be greatly appreciated.

hanks,
Steve

[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 (2)

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

.

__,_._,___