Find and highlight cells within different ranges.

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Find and highlight cells within different ranges.

06-17-2022, 03:17 PM

p45cal

Windows 10 Find and highlight cells within different ranges.

Office 2019

Expert

Join Date: Apr 2014

Posts: 948

Code:

=and(Len($C$2)>0,isnumber(search($c$2,b4)),isnumber(match(row(b4),row(indirect($a$2 & ":" & $b$2)),0)))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to highlight the cells using conditional formatting?	LearnerExcel	Excel	1	01-01-2019 01:43 AM
Copy & paste 2 ranges of cells	trevorc	Excel Programming	14	12-02-2018 03:08 PM
How to highlight cells using Vlookup / conditional formatting	mikehk	Excel	2	09-18-2017 07:30 PM
Take String of numbers, expand ranges, sort, then compress back into ranges	AustinBrister	Word VBA	19	08-22-2016 05:18 PM
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:36 PM.