+ Reply to Thread
Results 1 to 3 of 3

Copy Certain Conditional Formatting Rules to Other Worksheet

  1. #1
    Registered User
    Join Date
    02-08-2017
    Location
    Virginia
    MS-Off Ver
    2010
    Posts
    77

    Copy Certain Conditional Formatting Rules to Other Worksheet

    Hello,

    I often am working in workbooks that have 10 to 15 tabs. Each tab requires that I have about 5 of the same conditional formatting rules, and 5 or so different rules.

    Is there any way to just copy over the 5 five that I need to other tabs/worksheets?

    Thank you!

  2. #2
    Forum Contributor
    Join Date
    12-18-2016
    Location
    London
    MS-Off Ver
    Microsoft 2013
    Posts
    145

    Re: Copy Certain Conditional Formatting Rules to Other Worksheet

    Paste special > Formats would carry over the conditional formatting.

    Try copying (Ctrl+C) and then paste special (Alt+E+S) and select Formats

  3. #3
    Registered User
    Join Date
    02-08-2017
    Location
    Virginia
    MS-Off Ver
    2010
    Posts
    77

    Re: Copy Certain Conditional Formatting Rules to Other Worksheet

    Hello,

    Wouldn't that copy over all conditionally formatted rules? Not just the ones that I am needing?

+ 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. Removing one of three conditional formatting rules on every worksheet (100+)
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2017, 04:24 PM
  2. [SOLVED] Conditional Formatting - 2 rules in 1
    By Leathermyth in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2015, 02:29 PM
  3. Conditional Formatting two rules
    By pauldaddyadams in forum Excel General
    Replies: 1
    Last Post: 11-21-2014, 11:15 AM
  4. [SOLVED] 2 rules for conditional formatting
    By alfgrey in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-04-2013, 10:57 AM
  5. conditional formatting rules for a cell on sheet 1 based on rules from sheet 2
    By jsard in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-15-2013, 09:22 AM
  6. Conditional Formatting with rules
    By howcroc in forum Excel General
    Replies: 6
    Last Post: 02-04-2011, 12:01 PM
  7. [SOLVED] Tool / Code to copy and paste only the conditional formatting rules
    By Andibevan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2006, 07:04 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