Highlight with Maching function as Pair

		Microsoft Office Forums > Microsoft Excel > Excel
Highlight with Maching function as Pair

FAQ

Thread Tools

Display Modes

04-17-2024, 11:57 PM

Pecoflyer

Windows 10 Highlight with Maching function as Pair

Office 2021

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Perhaps a CF like

Code:

 =ISNUMBER(SEARCH(TEXTJOIN("",,$B6,$C6),TEXTJOIN("",,$K$6:$L$157)))

applied to data in col B and C ? If you need the same in K and L adapt the formula to that range

Attached Files

MATCH HIGHLIGHT.XLSX (32.9 KB, 5 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

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
Restrict Editing function disable insert textbox function	IanM_01	Word	5	11-21-2015 02:29 AM
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 03:04 AM.