luis.carrion
Board Regular
- Joined
- Mar 26, 2010
- Messages
- 246
I have two excel sheet one named "Total List on 1149" and the other one named "PROSPERITY FEPP". I need a macro that will open excel workbook named "PROSPERITY FEPP" and if the name in column B from the sheet named "Total List on 1149" matches column G from the esxcel named "PROSPERITY FEPP" highlight row in yellow and if one of the name in excel workbook named "Total List on 1149" is not found hightlight in red but in this name only.