Thread: [Solved] Find and highlight cells within different ranges.
View Single Post
 
Old 06-17-2022, 06:45 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
It's possible with conditional formatting (in cells B4:B30 in the attached):
Code:
=AND(ISNUMBER(SEARCH($C$2,B4)),ISNUMBER(MATCH(ROW(B4),ROW(INDIRECT($A$2 & ":" & $B$2)),0)))
The formula used is in column I but this is not needed - it was only for development of the CF formula.



Is vba a must?
Attached Files
File Type: xlsm msofficeforums49224Book1.xlsm (18.2 KB, 7 views)
Reply With Quote