Results 1 to 14 of 14

Color each selected range and compare for unique values (without Conditional Formatting)

Threaded View

  1. #1
    Registered User
    Join Date
    12-12-2015
    Location
    Latvia
    MS-Off Ver
    MS Office 2016
    Posts
    13

    Question Color each selected range and compare for unique values (without Conditional Formatting)

    I have a column with more than 10000 rows.

    What I need to do is find unique value in each selection group and color in orange this group if there is unique value.

    For example numbers 2 and 3 are different and these 2 rows need to color in orange as there are unique values in the group. If there are numbers 5 and 5 (duplicate) then need to color in green both numbers in that group and so on - macro compare values and color each group separately. If there is 17 25 26 3 3 where some numbers are unique and some are duplicate then also need to color in orange this group. If there is only one number in each group then do nothing and go to the next comparison group till all routine is done.

    Sounds like very easy but I am really stuck and Google also is not on my side to help.

    Sample I have added below.

    1

    2
    3

    4

    1

    5
    5

    6

    7
    7

    8

    9
    9

    10
    10

    11

    5

    4

    9

    8

    12

    13

    14
    15

    16

    3

    17

    18
    18

    12
    19

    20
    7

    6

    12
    21
    12

    5

    18
    19
    5

    5

    22

    17
    17

    23
    23

    7
    20

    24

    17
    25
    26
    3
    3

    27
    28
    Last edited by 7absinth; 03-16-2021 at 06:21 AM.

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: 05-22-2020, 02:46 PM
  2. VBA for conditional formatting based on user selected color
    By phrankndonna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2017, 09:55 AM
  3. Conditional formatting: how to compare multiple values
    By Aleksandramailas in forum Excel General
    Replies: 10
    Last Post: 08-24-2017, 02:15 PM
  4. Replies: 5
    Last Post: 07-27-2014, 04:43 AM
  5. [SOLVED] Sum selected values in matrix based on date range as well as unique identifier in row
    By smansyd in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-09-2014, 07:56 PM
  6. Using conditional formatting to compare values
    By Celabe in forum Excel General
    Replies: 5
    Last Post: 01-06-2010, 11:48 AM
  7. Conditional formatting: No background color when list item is selected
    By earthtodan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-27-2008, 09:18 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