LBee
New Member
- Joined
- Dec 25, 2021
- Messages
- 20
- Office Version
- 365
- 2019
- Platform
- Windows
I might be on an impossible mission - I have no idea how to solve my problem, and on top of that I'm also having a hard time trying to explain what I want
What im trying to accomplish is looking in column C - if value has more than 2 digits, and is present any part of column A, I want to highlight both rows.
If we take it row-by-row, there is no match in C1 (we wont look at it beacuse it only contains 1 digit), same goes for row 2 and 3.
C4 has a match in A1, and row 1 and 4 will be highlighted. C5 has a match in A2 and row 2 and 5 will be highlighted.
C6 has no match, and will stay white.
The end goal would be that row 1,2,4,5,7,8,11 and 13 would be highlighted.
Is the above possible? (and does my description make sense at all?)
What im trying to accomplish is looking in column C - if value has more than 2 digits, and is present any part of column A, I want to highlight both rows.
If we take it row-by-row, there is no match in C1 (we wont look at it beacuse it only contains 1 digit), same goes for row 2 and 3.
C4 has a match in A1, and row 1 and 4 will be highlighted. C5 has a match in A2 and row 2 and 5 will be highlighted.
C6 has no match, and will stay white.
The end goal would be that row 1,2,4,5,7,8,11 and 13 would be highlighted.
Is the above possible? (and does my description make sense at all?)
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 1-123-1 | 1 | ||||
2 | 1-234-1 | 2 | ||||
3 | 1-345-1 | 3 | ||||
4 | 1-456-1 | 123 | ||||
5 | 1-567-1 | 234 | ||||
6 | 1-678-1 | 555 | ||||
7 | 1-789-1 | 910 | ||||
8 | 1-890-1 | 333 | ||||
9 | 1-910-1 | 445 | ||||
10 | 1-101-1 | 554 | ||||
11 | 111-1 | 333 | ||||
12 | 1-222 | 713 | ||||
13 | 333 | 888 | ||||
14 | ||||||
Sheet1 |