+ Reply to Thread
Results 1 to 4 of 4

Conditional formatting of duplicate value for multiple columns

  1. #1
    Registered User
    Join Date
    06-21-2022
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Microsoft 365 Apps for enterprise Version 2205 (Build 152225.20288)
    Posts
    1

    Question Conditional formatting of duplicate value for multiple columns

    Hi,

    I'm not sure if it is entirely possible, but I hope somebody can help if it is.

    I am currently running a reviews campaign for my company, and looking to highlight cells where the person has shown up more than once, and already left a review.

    My excel sheet is large, and going to continue growing, so it may be difficult to look back and see if we have already had a review back from somebody who has left feedback previously.

    On the attachment you should see that there is a list of people who have given us feedback (not the real names), and some have given feedback more than once. For example, Clyde has left a review already, so I want to see if we can highlight the duplicate value in red to show that Clyde has already left a review after previous feedback. In comparison, I want it to be left blank if the person is a duplicate value after leaving previous feedback, but has not left a review like with Faye. So that I can message Faye again for her review whilst leaving Clyde out.

    I don't mind if there needs to be a different column or anything added, I am just hoping for an easy way to see if somebody has already given a review. Also, it doesn't need to be highlighted if it doesn't work like that - happy with anything!

    Please let me know if you know any way this can be done
    Attached Images Attached Images

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,341

    Re: Conditional formatting of duplicate value for multiple columns

    Test ........

  3. #3
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,341

    Re: Conditional formatting of duplicate value for multiple columns

    Hi Tibudd,

    Ì'm sorry I can not post, what I want to post (the answer), because I get the message
    I get the message I'm not allowed to post links, because I'm a mew member

    I'll try later.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Conditional formatting of duplicate value for multiple columns

    Quote Originally Posted by HansDouwe View Post
    Hi Tibudd,

    Ì'm sorry I can not post, what I want to post (the answer), because I get the message
    I get the message I'm not allowed to post links, because I'm a mew member

    I'll try later.
    That is correct, the forum wont allow links to be posted until you have at least 10 posts. This is an attempt to help prevent spam
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] Conditional Formatting highlights none duplicate based on rows & columns
    By chaiyya345 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-01-2021, 04:52 AM
  2. [SOLVED] Conditional formatting - duplicate entries across 3 columns
    By jbrooks1988 in forum Excel General
    Replies: 2
    Last Post: 07-26-2016, 03:56 AM
  3. [SOLVED] Conditional formatting duplicate values in multiple columns
    By PowerZ in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-08-2016, 08:04 AM
  4. [SOLVED] Conditional Formatting Duplicate Value with 2 columns
    By raffi123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-21-2014, 04:12 PM
  5. [SOLVED] Conditional Formatting: Duplicate rows based on multiple columns.
    By Old4xford in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-08-2014, 11:25 AM
  6. [SOLVED] match duplicate pair value ONLY between 2 columns using conditional formatting
    By yogi_himalayan in forum Excel General
    Replies: 4
    Last Post: 04-04-2014, 04:54 PM
  7. Conditional Formatting duplicate data in columns
    By DuckMan72 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-13-2013, 05:19 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