|
|
#6
06-17-2022, 02:40 PM
|
|||
|
|||
I'm sorry, I have been trying for a hour and I can't figure out how to include this in the original formula. =AND(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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode