+ 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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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
    447

    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
    2,143

    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)

Similar Threads

  1. Worksheet Wide Conditional Format
    By ajocius in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2018, 10:26 AM
  2. Conditional Formatting for a Conditonal format on other worksheet
    By jenna_max in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2014, 03:31 AM
  3. Conditional Format Worksheet Tabs
    By tommyfernandez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2013, 01:07 PM
  4. Conditional Format Worksheet Tabs
    By tommyfernandez in forum Excel General
    Replies: 1
    Last Post: 11-27-2013, 12:58 PM
  5. Conditional Format for two different tabs in one worksheet
    By Dynatnt1 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-29-2012, 03:39 AM
  6. Replies: 0
    Last Post: 05-20-2011, 02:33 PM
  7. Replies: 7
    Last Post: 06-30-2010, 11:53 AM

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