Hello,
Here is my problem. Any pointer in the right direction is greatly appreciated.
I have 2 sheets in the same workbook:
Sheet 1 has 2 columns: "Factor" and "Threshold". There are many unique factors, each having its own numerical threshold.
Sheet 2 has many columns, relevant being "Company","Factor", "Old Value" and "New Value".
There are many companies, each has different set of Factors, and appropriate Old and New Values.
What I need to do is to go through Sheet 2, check every Factor, check the difference between Old and New Value, and highlight the row where the difference is larger than the threshold for that Factor on Sheet1.
Please let me know if any of this is unclear. Any help is greatly appreciated.
Regards,
Lana
Bookmarks