Microsoft Office Forums - View Single Post - [Solved] Find and highlight cells within different ranges.

Thread: [Solved] Find and highlight cells within different ranges.

View Single Post

Old

06-17-2022, 02:40 PM

14spar15

14spar15 is offline

14spar15 uses Windows 7 64bit

Windows 7 64bit 14spar15 uses Office 2010 64bit

14spar15 uses Office 2010 64bit

Office 2010 64bit

Advanced Beginner

The original poster

Join Date: Mar 2011

Posts: 97

14spar15 is on a distinguished road

Default

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)))

Reply With Quote