Ineedhelpaz
New Member
- Joined
- Sep 23, 2014
- Messages
- 3
Excel 2007 question
I am attempting to highlight several thousand values in column B based on values in column A. An example...
A. B.
1. 1.
2. 1.
3. 2.
5. 4.
10. 9.
If 1, 2, 3, 5, 10 occur in column B at all I need all instances of them highlighted. Using duplicate values does not work since duplicate values in B that don't exist in A are highlighted.
I am attempting to highlight several thousand values in column B based on values in column A. An example...
A. B.
1. 1.
2. 1.
3. 2.
5. 4.
10. 9.
If 1, 2, 3, 5, 10 occur in column B at all I need all instances of them highlighted. Using duplicate values does not work since duplicate values in B that don't exist in A are highlighted.
Last edited: