Lock a cell based on another Cell in the entire sheet [Closed]

Report
-
 Blocked Profile -
Hello,
I have drop down selection (Yes/No) in Column A, and I need to lock corresponding cell in Column B if the result is "No" in Column A. Please help.