+ Reply to Thread
Results 1 to 7 of 7

Insert Values Only b/c of conditional formatting

  1. #1
    Registered User
    Join Date
    06-14-2012
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    13

    Insert Values Only b/c of conditional formatting

    I am attempting to cut rows of data from one sheet "Data2" and insert into another sheet "Check List"
    The problem is that I have conditional formatting on "Check List" sheet. When I insert rows of data into "Check List" sheet is screws up my conditional formatting.

    Is there a work around this? Speical Paste Values Only?

    Please Login or Register  to view this content.
    Thanks
    Nate
    Last edited by Cutter; 08-29-2012 at 10:11 AM. Reason: Added code tags

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: Insert Values Only b/c of conditional formatting

    Hello nahge123,

    I could not replicate your "Problem". I have even changed your code as per the attached WorkBook, and everything works fine without messing up any Conditional Formatting.

    I think the problem might be with how you have set-up ,or formulated your Conditional Formatting.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    06-14-2012
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Insert Values Only b/c of conditional formatting

    I am highlighting rows based on values in a particular column. I did not do the conditional formatting in VBA rather used the Conditional Formatting under tab home.

    Will post sheet soon.

  4. #4
    Registered User
    Join Date
    06-14-2012
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Insert Values Only b/c of conditional formatting

    Here is a copy of the sheet. It will conditional format on Check List. But when I insert new data, it throws conditional formatting out of wack. Should be highlighting rows based on values in columns.
    Attached Files Attached Files

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: Insert Values Only b/c of conditional formatting

    I still cannot see a problem.

    But when I insert new data, it throws conditional formatting out of wack.
    How do you insert new data and where, so that it throws conditional formatting out of wack ?

    Do you perharps insert new rows?

    Your CF Formulas will only respond if you enter "Problem" in Column C, "Work" in Column K and so on. The Program does exactly that.

  6. #6
    Registered User
    Join Date
    06-14-2012
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Insert Values Only b/c of conditional formatting

    I'm sorry when I look at it closer what I believe is causing the error is that I have three blank columns "A,B,C". So when the new data is inserted it is shifting the rows D:AZ and not column "A,B,C". How do I insert and shift all rows down even the blanks in column "A,B,C"?

    Also if you the module "hit the button" a couple of time the conditional formation "applies to" is changing. Check the "applies to" prior to running the code. Then check afterwards. Different.

    Not sure if it is supposed to work that way or not. Extremely new to VBA.

    Thanks again.
    Attached Files Attached Files
    Last edited by nahge123; 08-29-2012 at 05:45 PM.

  7. #7
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,077

    Re: Insert Values Only b/c of conditional formatting

    Hello nahge123,

    It is just a matter of getting the "Ducks in a row", otherwise they will be quacking all over. In the attached WorkBook, I have changed the "Applies" to parameters in your Conditional Formatting (I have not changed N to Q though, you can do that bit), and adjusted the VBA Code so as not to interfere with the blank Columns A,B & C.

    Hope that clears it up for you.

    Also see the "Please consider" note at the bottom of this post.
    Attached Files Attached Files

+ 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