Hello bino1121,
It's great to hear from you on our platform. I have found solutions to both your problems after exploring the attached Workbook.
In your first problem, you want to apply conditional formatting if a value on Ex1A is present on EX1B and then change that value on EX1B in RED...