open a comment to cell range upon true condition then removing comment on false condition

I want to have Range B4 to B49 if = "PRIVATE", or "Private", or "private" then
open comment window and say "Enter Patient Name Here" else if not any of the entries above then
delete the comment.

Thanks In Advance.