Consulting

Results 1 to 2 of 2

Thread: Conditional Format:Need to compare 2 cells with any other 2 cells for the same number

  1. #1
    VBAX Regular
    Joined
    May 2018
    Location
    Sydney
    Posts
    57
    Location

    Conditional Formatting Help Needed

    Hi all,

    I'm trying to conditionally format the below range to tell me if there are 2 identical numbers anywhere else in the range.
    I just can't get my head around the appropriate formula

    For example

    The yellow highlighted cells shows what I want
    The Red Groups are not what I want even though the the numbers are the same, they aren't "grouped"

    Only the C&D, E&F, G&H, I&J, K&L, M&N Groups I am interested in please.


    Last edited by Grade4.2; 09-11-2022 at 12:10 AM. Reason: More Accurate Header

  2. #2
    VBAX Regular
    Joined
    May 2018
    Location
    Sydney
    Posts
    57
    Location
    This an example picturehelp needed.jpg
    If you only ever do what you can , you'll only ever be what you are.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •