+ Reply to Thread
Results 1 to 2 of 2

Copy Conditional Formatting

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    37

    Copy Conditional Formatting

    Hi fellow Excel-fans ;-)

    I have a question about copying conditional formatting to other workbooks.

    I need to adjust quite a lot of conditional formatting in more than 40 Workbooks. but the Formatting is the same in every one of them..
    So, in order not to do it 40 times, i'd like to create the formatting once, in a seperate sheet, then copy it via Macro to all other sheets.

    how is that possible? can anyone give me a hint?

    Thank you in advance!

    BR Pascal

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Copy Conditional Formatting

    http://www.experts-exchange.com/Soft..._28262180.html
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

+ 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. Excel 2007 : Copy Conditional Formatting
    By Shajeermm in forum Excel General
    Replies: 1
    Last Post: 05-09-2012, 07:18 AM
  2. 1) How to do a conditional copy/ap of a row into a new tab (2) Conditional formatting
    By rajivkohli in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-08-2011, 01:41 PM
  3. Conditional Formatting - Can you copy them?
    By alexschecter in forum Excel General
    Replies: 5
    Last Post: 08-07-2008, 04:24 AM
  4. copy conditional formatting
    By ajitbmunj in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-29-2005, 12:05 PM
  5. [SOLVED] Copy conditional formatting
    By Hari Prasadh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2005, 09:07 AM

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