+ Reply to Thread
Results 1 to 7 of 7

Conditional format to multiple worksheet

  1. #1
    Registered User
    Join Date
    11-08-2008
    Location
    Montreal
    Posts
    57

    Conditional format to multiple worksheet

    Is it possible to create macro to copy/paste Conditional format to multiple worksheet in same workbook?

    I have a workbook with 65 worksheets, I want to create Conditional format, to every sheet, same format is there a way this to achieve with macro?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    48,666

    Re: Conditional format to multiple worksheet

    1. Why on do you need so many worksheets? How on earth do you find anything???

    2. If you use Group mode, what you do to 1 cell in a WS gets applied to all cells in that group, so maybe thats an option where VBA isnt required?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-08-2008
    Location
    Montreal
    Posts
    57

    Re: Conditional format to multiple worksheet

    This is a suppliers price book thats why I have so much sheets

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    48,666

    Re: Conditional format to multiple worksheet

    Did you try the Group Mode, as suggested?

  5. #5
    Registered User
    Join Date
    10-08-2019
    Location
    Houston, TX
    MS-Off Ver
    Office 365
    Posts
    12

    Re: Conditional format to multiple worksheet

    I would suggest using VBA to loop through each worksheet in the workbook, and then apply the same conditional formatting to the same range of cells on each worksheet. Note, the example below only adds one conditional formatting rule and loops it through to all sheets. You can add multiple rules by adding additional "Add" methods inside the loop.

    Please Login or Register  to view this content.

  6. #6
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    313

    Re: Conditional format to multiple worksheet

    IS the issue solved ?
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  7. #7
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    1,441

    Re: Conditional format to multiple worksheet

    Quote Originally Posted by hyewiz View Post
    Is it possible to create macro to copy/paste Conditional format to multiple worksheet in same workbook?
    You answered your question yourself ...
    The following commands in any loop for the respective sheet range/sheets ranges:

    from => .Copy
    where => .PasteSpecial xlPasteAllMergingConditionalFormats

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1