Condition statement isnt working , any ideas ?

I would like to highlight certain data (ID) and pop out a message based on the following IF statement

I have two Workbook - Book 1 and Book 2
I need to check the ID ( Book1 - Column S) against ( Book 2 - Column J) and execute IF statement

If (ID is found) ,
if (Book 2 - Remarks Column"P") = Open A/R OR Merged Then
Highlight "Blue" (row in book1)
Message pop out "Confirm Delete?"
else
Highlight "Green" (row in book1)
Else (ID is not found)
Highlight "Red" (row in book1)

Any ways to solve this ?

Thanks in advance

Need it urgently

Cross Ref: http://www.mrexcel.com/forum/excel-q...ml#post4226874

Please Login or Register  to view this content.