Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-17-2024, 11:31 PM
stricky stricky is offline Highlight with Maching function as Pair Windows 10 Highlight with Maching function as Pair Office 2019
Novice
Highlight with Maching function as Pair
 
Join Date: Jun 2023
Location: Bangladesh
Posts: 25
stricky is on a distinguished road
Default Highlight with Maching function as Pair

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
Attached Images
File Type: png TEST.png (81.4 KB, 22 views)
Attached Files
File Type: xlsx MATCH HIGHLIGHT.XLSX (32.6 KB, 6 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Compair two pair of cells: function usage and_woox Excel 5 01-31-2023 01:12 AM
Highlight with Maching function as Pair Restrict Editing function disable insert textbox function IanM_01 Word 5 11-21-2015 02:29 AM
Highlight with Maching function as Pair Is there a function to easily and quickly highlight? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft