+ Reply to Thread
Results 1 to 3 of 3

Condition Formatting duplicate values on the same row

  1. #1
    Forum Contributor
    Join Date
    10-15-2013
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2007
    Posts
    218

    Condition Formatting duplicate values on the same row

    Hi All,

    Trying to make an answer key for multiple choice grid.

    This is what I have:

    1 a b c d e e
    2 a b c d e c
    3 a b c d e a
    4 a b c d e e
    5 a b c d e d
    6 a b c d e e
    7 a b c d e a
    8 a b c d e b
    9 a b c d e d
    10 a b c d e a

    The answers are on the far right. All the letters are in their own columns.

    But I would like the box with the answer in the middle (A-E) to turn red. Is there a condition format for this?

    Thanks,

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Condition Formatting duplicate values on the same row

    use formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    make it apply to
    Please Login or Register  to view this content.
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    10-15-2013
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2007
    Posts
    218

    Re: Condition Formatting duplicate values on the same row

    PERFECT! Thanks!

+ 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. Conditional Formatting and Duplicate Values
    By bgarner10 in forum Excel General
    Replies: 2
    Last Post: 01-01-2016, 09:18 PM
  2. condition formatting for list of values from key values of appropriate match
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2013, 10:13 PM
  3. [SOLVED] Help with Conditional Formatting Duplicate Values
    By alcharbonneau in forum Excel General
    Replies: 6
    Last Post: 02-26-2013, 09:09 PM
  4. How to highlight duplicate values after certain condition is met
    By mstjohn1974 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-14-2013, 08:57 AM
  5. Conditional formatting for duplicate values
    By kris26 in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 03-21-2012, 06:51 AM
  6. Replies: 2
    Last Post: 09-28-2011, 09:12 AM
  7. Ignore Duplicate Values In Conditional Formatting
    By mightyeskimo in forum Excel General
    Replies: 13
    Last Post: 09-18-2010, 01:28 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