Hi all,
I'm a complete VBA newbie, and I'm trying to learn how to do things as I go. I was wondering how I would get the following done-
I have a workbook with two sheets, and each sheet contains multiple columns. I would like to find out how to write a script so that I can compare numbers in column A (ignoring all other columns) on both sheets, and highlight any values not on both sheets in red.
I have been able to do this with conditional formatting, but I would like to see if this is possible using VBA.
Thanks!
Bookmarks