+ Reply to Thread
Results 1 to 3 of 3

Comparing multiple cells for differences

  1. #1
    Registered User
    Join Date
    10-20-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    2202 (Build 14931.20858 Click-to-Run)
    Posts
    50

    Thumbs up Comparing multiple cells for differences

    I've got a spreadsheet for an aircraft type, my airline has a different tpye. Manufacturer has said most tasks are similar but I need to run a check. I've attached spreadsheet.
    1. Rows 2-7 show 6 different tasks for AC type 1
    2. Rows 10-15 show 6 different tasks for AC type 2
    3. Most of the tasks are similar! However I've purposely made Q7 different to Q15
    4. I'd like this difference to be flagged...
    5. The original spreads are on two different sheets, so preferably solution would drag from two different sheets and output on one

    Thank you for helping me with this. I've removed sensitive information.
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Comparing multiple cells for differences

    Please try Conditional Formatting select Q2:Q7 press ALT H L N > use a formula > =Q2<>Q10 > format > fill > select color > OK

  3. #3
    Registered User
    Join Date
    06-09-2020
    Location
    Cambodia
    MS-Off Ver
    Window 10
    Posts
    3

    Re: Comparing multiple cells for differences

    Try
    Conditional formatting>New rule>use a formula to determine which cell to format:
    =Q2<>Q7
    Format>Fill color>OK

+ 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. [SOLVED] comparing 2 workbooks, looking for differences in quatities
    By matiiss in forum Excel General
    Replies: 0
    Last Post: 09-16-2016, 03:41 AM
  2. Replies: 1
    Last Post: 11-12-2014, 10:57 AM
  3. [SOLVED] Comparing two sheets for differences
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-16-2013, 06:43 AM
  4. [SOLVED] Comparing 2 Lists to Identify Differences
    By ORRACLE1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-10-2012, 02:26 PM
  5. Replies: 1
    Last Post: 11-15-2010, 12:24 PM
  6. Comparing differences between two columns
    By MI_Analyst in forum Excel General
    Replies: 1
    Last Post: 11-02-2010, 06:51 AM
  7. [SOLVED] Comparing two data ranges for differences.
    By jason.r.swinehart in forum Excel General
    Replies: 0
    Last Post: 01-12-2006, 03:55 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