+ Reply to Thread
Results 1 to 3 of 3

Grouping like values with conditional formatting

  1. #1
    Registered User
    Join Date
    06-28-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    28

    Grouping like values with conditional formatting

    Is there an easy way to group duplicate values using conditional formatting.

    I want to apply conditional formatting to column A so that grouped values are highlighted resulting in what is shown in column B.

    Screenshot 2023-01-22 215055.png

    I know that I can use conditional formatting to say colour cells which contain 'A' and cells which contain 'B' etc but this relies on having to manually go in and set up the conditional formatting for each value. What I'm looking for is a way to automatically apply this formatting to colour all unique values.

    Not sure this will be possible, but worth an ask

    Thanks

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,467

    Re: Grouping like values with conditional formatting

    You could derive a list of unique values using a formula (which uses INDEX/MATCH/COUNTIF) in some other column, say column E, and then set up some CF conditions so that if cells in column B =E$2 then yellow, if = E$3 then orange, if = E$4 then green, and so on, and this would work even in XL2003, which your profile states that you are using. With later versions there could be other ways.

    Hope this helps.

    Pete

  3. #3
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,639

    Re: Grouping like values with conditional formatting

    You would have to create a CF rule for each color.

    If you are interested in a VBA solution please provide a sample file showing what colors you want to use. However, you may be looking for an easier way.
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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: 1
    Last Post: 11-06-2020, 05:45 PM
  2. Conditional Formatting Template - Formatting without values
    By tkelbel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2019, 12:20 PM
  3. Grouping cells for conditional formatting
    By RossCR in forum Excel General
    Replies: 1
    Last Post: 11-30-2016, 12:19 PM
  4. [SOLVED] Conditional Formatting with IF for 2 values
    By Dee2015 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2015, 11:47 AM
  5. Replies: 4
    Last Post: 07-26-2014, 02:35 AM
  6. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  7. Replies: 1
    Last Post: 09-25-2013, 10:05 AM

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