Giah98,

you appear to ahve tried thsi with conditional fomatting already.
Try cahnging the fomula in the conditional format in cell b15 to =B36<>"" and try again - that may be a better way to show it.
It does not however lock the cell.

That can only really be accomplished with VBA.