+ Reply to Thread
Results 1 to 4 of 4

Solve: Why Conditional Formatting is highlight incorrect differences in large data sets

  1. #1
    Registered User
    Join Date
    05-11-2021
    Location
    Munster, Ireland
    MS-Off Ver
    365
    Posts
    3

    Solve: Why Conditional Formatting is highlight incorrect differences in large data sets

    See attached file.
    Could you explain why the data is not showing the correct differences. ( ie BI2 surnames are different they should be coloured but they are not) it also is showing cells that have no changes.
    It appears the the formatting (error) has offset the result 9 rows below where the difference is.

    I have entered the condition on the 2nd tab, 6 Report Template 1.0
    I used the following, select full sheet [ 2nd tab, 6 Report Template 1.0 ],
    home, conditional formatting, new rule, use a formula to determine which cells to format;

    [ 2nd tab, 6 Report Template 1.0 ] Select first cell of the students (A1) working(f4 x 3 times remove absolute) <> ( Not equal to) change to master workings [ 1st tab, 5 Report Template 1.0 ] (A1 full or top left cell ) press f4 x 3 again remove absolute then changed the fill format {change format} red and yellow fill.

    I would appreciate help solving this thank you.
    I will be using this to help grade students, where I can easily identify errors to a given solution.

    Regards,

    Alexander
    Last edited by AI.LerningOnline; 05-11-2021 at 07:08 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    21,265

    Re: Solve: Why Conditional Formatting is highlight incorrect differences in large data set

    The file posted (to me) bears no relationship to the description you gave: it appears to be a payroll calculation!

  3. #3
    Registered User
    Join Date
    05-11-2021
    Location
    Munster, Ireland
    MS-Off Ver
    365
    Posts
    3

    Re: Solve: Why Conditional Formatting is highlight incorrect differences in large data set

    They are payroll values, I am using conditional formatting to highlight values that deviate from the master file .(the 2nd tab "6" is a test, simulating a students response to a sample question)
    In this case, the first tab "5" .
    The only cells that should be affected by the conditional format are PPSN and surnames.
    This seems to be the case though the results are offset by 9 rows. I cannot explain this.
    Last edited by AI.LerningOnline; 05-11-2021 at 04:13 PM. Reason: cant work out how to remove this post

  4. #4
    Registered User
    Join Date
    05-11-2021
    Location
    Munster, Ireland
    MS-Off Ver
    365
    Posts
    3

    Re: Solve: Why Conditional Formatting is highlight incorrect differences in large data set

    They are payroll values, I am using conditional formatting to highlight values that deviate from the master file .(the 2nd tab "6" is a test, simulating a students response to a sample question)
    In this case, the first tab "5" .
    The only cells that should be affected by the conditional format are PPSN and surnames.
    This seems to be the case though the results are offset by 9 rows. I cannot explain this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 10-29-2015, 02:35 PM
  2. How do I compare 2 sets of data and highlight differences?
    By Perplexed1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  3. [SOLVED] How do I compare 2 sets of data and highlight differences?
    By Perplexed1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  4. [SOLVED] How do I compare 2 sets of data and highlight differences?
    By Perplexed1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] How do I compare 2 sets of data and highlight differences?
    By Perplexed1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. How do I compare 2 sets of data and highlight differences?
    By Perplexed1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] How do I compare 2 sets of data and highlight differences?
    By Perplexed1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

Tags for this Thread

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