+ Reply to Thread
Results 1 to 5 of 5

Copy the result of conditional formating

  1. #1
    Registered User
    Join Date
    12-20-2005
    Posts
    41

    Copy the result of conditional formating

    I have a spread sheet, that contains numerous formulas and conditional formating... the workbook has several sheets.. I need to forward the sheet I am refering to.. without the formulas (paste special values) and maintain the result of the conditional formating, however paste special formats does not do it... can anyone help me with this issue..

    Thanky you very much

    Randy

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Hi,

    First do paste special value.
    Then do paste special formula.

  3. #3
    Registered User
    Join Date
    12-20-2005
    Posts
    41
    Thank you for your response... I tried what you suggested but it leaves the conditional format formula in there...what I need it a sheet that is the mirror image of the original but does not have any formulas... It will not have the other sheets to refer too... it becomes stand alone information...

    Any Ideas

    Thank you Randy

  4. #4
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Hi,

    Sorry there was typo error in my reply

    Copy the content
    Then First do copy paste value
    Then do copy paste format

  5. #5
    Registered User
    Join Date
    12-20-2005
    Posts
    41
    Sorry for the delay in reply.... I did not work on it over there weekend.... That is what I have been trying to do... but It does not seam to work correctly... and when I (on the sheet I am copying too) view...(or edit) the conditional format formula is still there...

    Thank you for all of your help.... hope I am just doing something wrong... do you have any idea..

+ 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