Closed Thread
Results 1 to 2 of 2

HELP: Copying data to cell with CF, the rules will change on its own

  1. #1
    Registered User
    Join Date
    04-04-2014
    Location
    singapore
    MS-Off Ver
    Excel 2010
    Posts
    78

    HELP: Copying data to cell with CF, the rules will change on its own

    I had previously posted a query on deconstructing 2 set of tables (with similar heading)(in sheet 1 & 2) & combine them side by side with similar heading (in sheet3) so as to use condition formatting to highlight the differences & visually i can compare them easily.

    1 group is 2 tables to compare. I have about 30 groups. So after creating the 1st group, i intended to use it as a template, without having to create the conditional formatting again & again. But after copying, the conditional formatting rules change. I am not sure why.

    I attached a sample of my template for reference.

    Sheet 1 - Table 1
    Sheet 2 - Table 2 & part of Table 1
    Sheet 3 - combine both Tables with similar column header side by side

    in Table 3, cell B3 rules are "=C5<>B5"

    SO the problem is when i copy data from Sheet 2, Table 2's Column Header B (cell f9 to f421) to Sheet 3, Column Header B2 (cell c5 onwards) the rules change to "=C5<>XFC5"

    Hope someone can solve this mystery.

    Thanks

    rules will change.xlsx

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: HELP: Copying data to cell with CF, the rules will change on its own

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 05-05-2014, 08:00 PM
  2. [SOLVED] Conditional Formatting - copying rules possible?
    By Apelcius in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2012, 04:11 PM
  3. Excel 2007 : Copying Conditional Format Rules
    By JohnDepierro in forum Excel General
    Replies: 1
    Last Post: 07-09-2012, 12:48 PM
  4. Copying conditional format rules
    By bombiro in forum Excel General
    Replies: 2
    Last Post: 11-10-2010, 03:15 PM
  5. Replies: 2
    Last Post: 01-03-2010, 05:21 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