Thread: [Solved] Find and highlight cells within different ranges.
View Single Post
 
Old 06-17-2022, 03:17 PM
p45cal's Avatar
p45cal p45cal is online now Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 867
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
Code:
=and(Len($C$2)>0,isnumber(search($c$2,b4)),isnumber(match(row(b4),row(indirect($a$2 & ":" & $b$2)),0)))
Reply With Quote