+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting changes when copying the worksheet

  1. #1
    Registered User
    Join Date
    02-03-2016
    Location
    Mexico
    MS-Off Ver
    seven
    Posts
    6

    Angry Conditional Formatting changes when copying the worksheet

    Hello. My file consists in making copies of the main work sheet to make some modifications to them and to finally export them as a PDF file. The problem is that i have a complicated hierarchy in my conditional formatting and is very important to preserve it in the eventual copies BUT THIS DOESN'T HAPPEN!! whenever i copy the main sheet, the copy sheet changes the conditional formatting and i cant change back it manually because there is a macro that does this a significant amount of times. Any help? if i cant repair this is there a way to change the hierarchy using the macro so that the problem can be solved intermediately and automatically?

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Conditional Formatting changes when copying the worksheet

    without your file no chance

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,332

    Re: Conditional Formatting changes when copying the worksheet

    you can also use VBA instead of conditional format to get colored cells
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Registered User
    Join Date
    02-03-2016
    Location
    Mexico
    MS-Off Ver
    seven
    Posts
    6

    Re: Conditional Formatting changes when copying the worksheet

    True but I have so many rules that migrate them to vba could be complicated, eventually if there is no solution I'm afraid i will have to do so.

+ 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. Copying Conditional Formatting
    By Kristine T. in forum Excel General
    Replies: 1
    Last Post: 12-12-2014, 02:06 AM
  2. [SOLVED] Conditional formatting when copying a worksheet; order of conditions changes
    By jazzmatazz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2014, 06:02 AM
  3. Copying conditional formatting
    By Dexter Stagg in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-29-2012, 12:35 PM
  4. copying conditional formatting
    By Lugar07 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-14-2011, 05:42 PM
  5. Replies: 4
    Last Post: 11-01-2009, 04:45 PM
  6. Copying conditional formatting
    By johnmitch38 in forum Excel General
    Replies: 2
    Last Post: 09-16-2009, 05:53 AM
  7. Copying Conditional Formatting
    By capndave in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-08-2008, 04:23 PM

Tags for this Thread

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