Results 1 to 2 of 2

Copying and pasting conditional formatting rules

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Tacoma, Washingtonn
    MS-Off Ver
    Excel 2019
    Posts
    254

    Copying and pasting conditional formatting rules

    I am sorry for re-posting this issue, but I never really got the resolution I was looking for. I have attached a sample program. I have several of these types of worksheets with several hundred names. I am trying to find a way to copy and paste the conditional formatting like it appears in C5:X6, C7:X8, C9:X10, C11:X12, and C13:X14 to the rest of my worksheet. Column A works fine. I was able to format each of those 5 areas starting in the C column individually, one at a time. I am hoping to find a quicker solution to applying that formatting to hundreds of names. I have tried playing with the $ sign in my reference cells, but can't seem to get that to work either. I have searched the web for a solution, but can't find one. Or maybe I am missing another solution. Anyway, thanks for any help provided.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] copying conditional formatting rules
    By nathandavies9 in forum Excel General
    Replies: 6
    Last Post: 02-23-2017, 05:34 AM
  2. Replies: 9
    Last Post: 05-13-2013, 05:43 AM
  3. Help with copying and pasting conditional formatting
    By toshea4 in forum Excel General
    Replies: 6
    Last Post: 03-19-2013, 04:19 PM
  4. Replies: 4
    Last Post: 11-08-2012, 11:33 PM
  5. [SOLVED] Conditional Formatting - copying rules possible?
    By Apelcius in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2012, 04:11 PM
  6. Replies: 1
    Last Post: 06-21-2012, 10:35 AM
  7. Conditional formatting rules split up when copying rows
    By finny388 in forum Excel General
    Replies: 1
    Last Post: 02-29-2012, 02:26 PM

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