+ Reply to Thread
Results 1 to 4 of 4

Macro to copy conditional formatting rules from sheet to sheet.

  1. #1
    Forum Contributor
    Join Date
    04-19-2016
    Location
    Michigan
    MS-Off Ver
    15.0
    Posts
    130

    Macro to copy conditional formatting rules from sheet to sheet.

    Good morning,

    Currently I am presented with an interesting problem. Everyday a software produces productivity reports for our plants.

    In the first worksheet, I have conditional formatting for my various stations.

    Second worksheet is generated from our app and has raw data.

    I wonder if I can script it so that these conditions apply to the second sheet as well, without needing to use the format painter between the two sheets?

    Thanks much!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,937

    Re: Macro to copy conditional formatting rules from sheet to sheet.

    CFs are copied when the cell is copied, so just use

    Please Login or Register  to view this content.
    If your cells don't line up perfectly, then you need to do a range-by-range copy/pastespecial....
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Contributor
    Join Date
    04-19-2016
    Location
    Michigan
    MS-Off Ver
    15.0
    Posts
    130

    Re: Macro to copy conditional formatting rules from sheet to sheet.

    Thanks, how would I be able to copy range by range.

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,937

    Re: Macro to copy conditional formatting rules from sheet to sheet.

    You need to identify cells or range blocks that are the source and destination of the copy and paste, and then code it in, for each specific pair:

    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)

Similar Threads

  1. Replies: 2
    Last Post: 05-22-2017, 03:12 PM
  2. 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
  3. [SOLVED] Conditional Formatting on a sheet with many rules
    By BrutalExcel in forum Excel General
    Replies: 3
    Last Post: 06-02-2013, 01:37 AM
  4. Replies: 9
    Last Post: 05-13-2013, 05:43 AM
  5. Replies: 0
    Last Post: 09-03-2011, 12:29 PM
  6. [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
  7. Conditional Formatting Help-rules for a grade sheet.
    By John Doe in forum Excel General
    Replies: 1
    Last Post: 08-31-2005, 10:05 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