![]() |
#1
|
|||
|
|||
![]()
I want to highlight/match between column C,D & K,L. but there is a catch. As you can see on Green marked area B&C ""13710 36"18"" (they are a pair) must match in the list of K,L ""13710 36"18"" column as a pair.
so Green marked pair C,D matches with K,L. But in K,L there is another pair RED ""13710 44"18"" that doesnt match with any pair in C,D and RED ""13710 32"18"" C,D is not available in K,L so i want to highlight those who matches as a pair. which pair doesnt match wont highlight (or highlight vice versa) matching will be done between this four colums |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Compair two pair of cells: function usage | and_woox | Excel | 5 | 01-31-2023 01:12 AM |
![]() |
IanM_01 | Word | 5 | 11-21-2015 02:29 AM |
![]() |
Verbum | Word | 3 | 02-05-2013 10:09 AM |
mapping from token to text/number pair | JettyGuy | Word | 0 | 08-13-2011 10:47 AM |
find - reading highlight - highlight all / highlight doesn't stick when saved | bobk544 | Word | 3 | 04-15-2009 03:31 PM |