I have a workbook with 52 worksheets. The first 2 hold base data fro the
rest. I need a macro that will compare one cell to a range of data from the
first 2 worksheets.
For example:on worksheet one I have a range a1:a500,consider this the base
data. On another worksheet i have one cell of data that needs to be compared
to the range mentioned above. If the data in the cell does not match the
range, it should change the data in the cell red.
As you can tell I am new at this, any help would be appreciated
Thanks
Bookmarks