Results 1 to 3 of 3

Conditional Formatting copy as like formulas paste special

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Conditional Formatting copy as like formulas paste special

    Hello Friends

    We are copying the output (May be text or numbers) from a formulas to text / numbers by using COpy > Psate Special > Values option.

    So the associativity is removed between the formulas and the output, in future even if we removed the inputs then the copied and pasted special as values will get the exact output.

    As like i need to use the same concept for conditional formatting. For certain conditions i text colored and text color filled the entire rows in a excel sheet, now my intension is i want to copy the row text to new sheet / file with removed conditional formatting but retaining the formats done by conditional formatting.

    Is there any way to do this ?

    thanks in advance

    thilag
    Last edited by thilag; 12-08-2015 at 01:29 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 13
    Last Post: 12-04-2012, 07:54 PM
  2. Conditional Formatting, VBA and Paste Special
    By lross in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2011, 07:49 PM
  3. Paste special cells with conditional formatting
    By Vipulparbat in forum Excel General
    Replies: 1
    Last Post: 08-24-2006, 04:49 AM
  4. [SOLVED] Paste Special - copy everything except formulas
    By VishalBade in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2006, 01:00 PM
  5. [SOLVED] Conditional formatting -- copy paste special won't change referenc
    By Ed in Biotech in forum Excel General
    Replies: 3
    Last Post: 07-20-2006, 02:00 PM
  6. Paste Special Formats Generated by Conditional Formatting
    By ExcelMonkey in forum Excel General
    Replies: 6
    Last Post: 05-22-2006, 02:10 PM
  7. [SOLVED] How to copy formulas to a new workbook? Paste Special is different
    By MS-Requestor in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-10-2006, 05:25 PM
  8. [SOLVED] Copy and Paste Special (Formulas) pastes cell value if numeric
    By korrin.anderson@gmail.com in forum Excel General
    Replies: 1
    Last Post: 05-02-2006, 01:20 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