+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting to Check Adjacent Values in Cells

  1. #1
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Conditional Formatting to Check Adjacent Values in Cells

    I've an excel sheet containing 3 sheets (Sheet1, Sheet2 and Sheet3) and would want to compare Sheet1 with Sheet2 and Sheet1 with Sheet3. There are 17 columns of data in each sheet with the primary key column being the first column in each sheet.

    I want to do a column-wise comparison of the sheets (based on the primary key column) to check whether the same data is present in all columns in all sheets.

    Is there any way to code a conditional formatting formula that will highlight non-matching columns ?
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

  2. #2
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Conditional Formatting to Check Adjacent Values in Cells

    Enclosed a sample workbook. Refer sheet named Sample Output.
    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)

Similar Threads

  1. Replies: 4
    Last Post: 07-25-2014, 05:17 AM
  2. Replies: 6
    Last Post: 06-03-2014, 08:40 PM
  3. [SOLVED] Conditional Formatting Based on Adjacent Cells and Values
    By stusic in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-03-2013, 03:59 PM
  4. Conditional formatting based on adjacent cell values
    By dberliner in forum Excel General
    Replies: 4
    Last Post: 07-28-2011, 12:42 PM
  5. Conditional Formatting on adjacent cells
    By ThatDamnRedhead in forum Excel General
    Replies: 4
    Last Post: 09-16-2010, 03:12 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