I have the need to highlight about 20K+ cells in one worksheet with cells referenced in another worksheet. Need a VBA loop solution for this. As example:
Have a sheet named "GoBaby" in which the cells need highlighting if they match the cell values referenced in sheet named "Matched" . So Matched A1 value is P3 so I need P3 on GoBaby highlighted. Then Matched A2 value is Z8 so I need Z8 on GoBaby highlighted. Then Matched A3 value is X18 so I need X18 on GoBaby highlighted. etc, etc.
Thanks in advance
Have a sheet named "GoBaby" in which the cells need highlighting if they match the cell values referenced in sheet named "Matched" . So Matched A1 value is P3 so I need P3 on GoBaby highlighted. Then Matched A2 value is Z8 so I need Z8 on GoBaby highlighted. Then Matched A3 value is X18 so I need X18 on GoBaby highlighted. etc, etc.
Thanks in advance