Hi,

I have a problem with the limitations of conditional formatting. I
need to compare a list of numbers to another without summing the whole
list. I need to compare A16:A500 on all selected sheets with a master
list of numbers on another sheet in the same workbook from A6:A4500.
Any matches that are found on the master list need to be highilighted
in yellow. Is there any way to create a macro which can do this
quickly as I'm running on a slow computer? Any help would be great.

Regards,
Mjack


---
Message posted from http://www.ExcelForum.com/