Hi Lisa,
Not sure I have the ability to put code together for this that implements conditioinal formatting of the nature I'm talking about. I still rely on recording macros and then editing to suit. VBA won't let me record conditional formatting steps.
Thanks,
Steve
--- In ExcelVBA@yahoogroups.com, 1z@... wrote:
>
>
> 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]
>
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
----------------------------------
Tidak ada komentar:
Posting Komentar