Thanks:  0
Likes:  0

# Thread: Conditional formatting ? numbers match highlight?

1. ## 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. ## Re: Conditional formatting ? numbers match highlight?

Your CF formula for D5 will be:

=D5=M5

3. ## 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. ## 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. ## 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. ## 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.

7. ## 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. ## Re: Conditional formatting ? numbers match highlight?

Originally Posted by zone709
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. ## 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

10. ## 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

#### Posting Permissions

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