+ Reply to Thread
Results 1 to 5 of 5

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,173

    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,173

    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.

+ 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