M
mjack003
Hi,
Could someone point me in the right direction of how I would go abou
creating a macro which would compare one range, say A1:A500 o
worksheet 1 to a second range, A1:A20 on all grouped worksheets. The
any numbers which match from the two ranges...would be highlighted i
yellow on worksheet 1. I can't seem to solve this problem and
imagine there is a pretty simple solution along the lines o
conditional formatting and countif but this is beyond me. Thanks fo
the help.
Mjac
Could someone point me in the right direction of how I would go abou
creating a macro which would compare one range, say A1:A500 o
worksheet 1 to a second range, A1:A20 on all grouped worksheets. The
any numbers which match from the two ranges...would be highlighted i
yellow on worksheet 1. I can't seem to solve this problem and
imagine there is a pretty simple solution along the lines o
conditional formatting and countif but this is beyond me. Thanks fo
the help.
Mjac