Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Conditional formatting ? numbers match highlight?

  1. #1
    Board Regular
    Join Date
    Mar 2016
    Posts
    1,547
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional formatting ? numbers match highlight?

    Hi I have on one sheet column M to R. If number in these cells match the same numbers from C to G. Then highlight those cells that match from C to G.

    So lets example if 5 is in M4 and 5 is then in D5. Highlight D5 any help thanks

  2. #2
    .
    Join Date
    Mar 2014
    Location
    Suffolk, UK
    Posts
    3,628
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting ? numbers match highlight?

    Your CF formula for D5 will be:

    =D5=M5

  3. #3
    Board Regular
    Join Date
    Mar 2016
    Posts
    1,547
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting ? numbers match highlight?

    yeah but I think I need the whole range. lets say the number 20 was in P12 and the number 20 was in C14, E15, F22 AND G18 . Then all these should highlight C14, E15, F22 AND G18. Since 20 is in P12. Basically my range is in any number from colum M to R matches any number from column C to G. To then highlight those numbers only from C to G

  4. #4
    .
    Join Date
    Mar 2014
    Location
    Suffolk, UK
    Posts
    3,628
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting ? numbers match highlight?

    OK, well that may need VBA, with which I can't help you - sorry. It would be so much better to tell us what you really want from the outset.

  5. #5
    Board Regular
    Join Date
    Mar 2016
    Posts
    1,547
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting ? numbers match highlight?

    ok I posted an image of what I'm looking to do, but I think this can be done using conditional Formatting. Trying to research it more.

    Excel 2016 (Windows) 32 bit
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    3
    Rick
    25
    8
    9
    32
    32
    4
    5
    12
    20
    25
    30
    4
    Frank
    4
    5
    6
    2
    2
    7
    5
    12
    22
    7
    30
    5
    Leo
    6
    1
    7
    2
    2
    4
    21
    12
    20
    8
    30
    6
    Maria
    3
    21
    8
    5
    5
    4
    5
    12
    20
    9
    30
    7
    Mary
    32
    12
    9
    6
    6
    4
    5
    12
    20
    25
    30
    Sheet: Sheet1

  6. #6
    Board Regular 63falcondude's Avatar
    Join Date
    Jan 2016
    Posts
    3,542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting ? numbers match highlight?

    Try highlighting C3:G7 (or however far down you need), Conditional Formatting, New Rule, Use a formula

    =COUNTIFS($M:$R,C3,$M:$R,"<>")

    Format yellow fill

    Edit: Shouldn't D3, E3, E6, D7, and E7 be highlighted too? Those numbers are found in columns M:R.
    Last edited by 63falcondude; Apr 21st, 2017 at 12:20 PM.

  7. #7
    Board Regular
    Join Date
    Mar 2016
    Posts
    1,547
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting ? numbers match highlight?

    BOOM it works. Sorry yes they should I probably missed it when highlighting manually. Thanks for the help happy I can use conditional formatting for this. Big help

  8. #8
    Board Regular 63falcondude's Avatar
    Join Date
    Jan 2016
    Posts
    3,542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting ? numbers match highlight?

    Quote Originally Posted by zone709 View Post
    BOOM it works. Sorry yes they should I probably missed it when highlighting manually. Thanks for the help happy I can use conditional formatting for this. Big help
    You're welcome. Glad to help. The example in post #5 greatly helped clear things up.

  9. #9
    Board Regular
    Join Date
    Mar 2016
    Posts
    1,547
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting ? numbers match highlight?

    Sorry wait I think I'm missing a little something. I see on the left that some numbers are not highlighting. Think a formual issue? If you have another sec thanks

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    2
    #
    #
    #
    #
    #
    #
    3
    Rick
    25
    8
    9
    32
    32
    4
    5
    12
    20
    25
    30
    4
    Frank
    4
    5
    6
    2
    2
    7
    5
    12
    22
    7
    30
    5
    Leo
    6
    1
    7
    2
    2
    4
    21
    12
    20
    8
    30
    6
    Maria
    3
    21
    8
    5
    5
    5
    5
    12
    20
    9
    30
    7
    Mary
    32
    12
    9
    6
    6
    4
    5
    12
    20
    25
    30
    8
    Mark
    2
    12
    10
    9
    9
    25
    5
    12
    20
    30
    30
    9
    Lou Nuts
    16
    20
    30
    6
    6
    4
    5
    12
    12
    25
    35
    10
    Frank
    4
    5
    6
    63
    5
    25
    5
    12
    20
    25
    25
    11
    Leo
    6
    1
    7
    45
    45
    7
    12
    12
    20
    25
    30
    12
    Maria
    3
    21
    8
    12
    12
    20
    5
    12
    20
    45
    30
    13
    Mary
    32
    12
    9
    45
    45
    4
    5
    12
    15
    25
    30
    14
    Mark
    2
    12
    10
    12
    12
    4
    25
    12
    20
    25
    30
    15
    Lou Nuts
    16
    20
    30
    20
    20
    4
    5
    12
    20
    23
    30
    16
    Frank
    25
    6
    8
    23
    25
    12
    5
    12
    20
    25
    50
    17
    Leo
    6
    7
    9
    26
    26
    4
    5
    12
    20
    25
    56
    18
    Maria
    3
    8
    10
    2
    2
    4
    5
    12
    20
    25
    25
    19
    Mary
    32
    9
    30
    5
    5
    4
    5
    12
    21
    25
    21
    20
    Mark
    2
    10
    6
    12
    12
    4
    5
    12
    20
    25
    20
    21
    Lou Nuts
    16
    30
    7
    56
    56
    4
    5
    12
    22
    25
    21
    22
    Frank
    2
    10
    8
    25
    25
    25
    5
    12
    23
    25
    21
    23
    Leo
    16
    30
    9
    30
    30
    4
    5
    12
    20
    25
    30
    Sheet: Sheet1

    Like I see 6 highlight but no 6 on right. Then I see 25 on left not highlighted but 25 is on right. Why countif? maybe match just matching numbers
    Last edited by zone709; Apr 21st, 2017 at 12:41 PM.

  10. #10
    Board Regular 63falcondude's Avatar
    Join Date
    Jan 2016
    Posts
    3,542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting ? numbers match highlight?

    I think that you applied the Conditional Formatting incorrectly. Highlight C3:G23 and then follow the steps outlined in post #6.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com