|
|
|
|
#1
06-17-2022, 09:48 AM
|
|||
|
|||
That works great. Doing this with a formula is perfectly fine. I only need to search one column so I used your first formula. I was not familiar with array formulas. One last thing. If I’m not searching and C2 is empty all of the range cells are highlighted. I’m trying to add an IF statement that would prevent this.
|
|
|
|
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
Hybrid Mode