+ Reply to Thread
Results 1 to 5 of 5

Anyone know a way to "Copy/paste Values" for conditional formatting?

  1. #1
    Registered User
    Join Date
    05-29-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    84

    Anyone know a way to "Copy/paste Values" for conditional formatting?

    I have a sheet that highlights cells based on conditional formatting. There is a portion of the data that I have to copy into another sheet and I want it to look the same way. I end up removing some data in the new sheet which also removes the highlights that were in place from the conditional formatting.

    Because the sheet I am copying from already looks exactly the way I want, I'm wondering if there is a way I can paste it into the new sheet so it maintains the highlighting the way it is (but not b/c of conditional formatting). Pasting formats won't work b/c that includes the conditional formatting as well. Anyone have any ideas?

  2. #2
    Forum Contributor BenMiller's Avatar
    Join Date
    12-06-2011
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Anyone know a way to "Copy/paste Values" for conditional formatting?

    Impossible. I'm sorry

  3. #3
    Registered User
    Join Date
    05-29-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    84

    Re: Anyone know a way to "Copy/paste Values" for conditional formatting?

    figured as much but I thought i'd take a shot.

  4. #4
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: Anyone know a way to "Copy/paste Values" for conditional formatting?

    You can copy and paste as a picture...

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Anyone know a way to "Copy/paste Values" for conditional formatting?

    whny cant you use CF on the new sheet? its not like it will be "visible" that you have used it, and you could just set the new Cf to what the old CF was based on
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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