Is there a macro or formula that I can use to automatically highlight row
once a comment is inserted. I included a sample below

Name Address contact Status
No

If I put no in the status comment, I would like to have the entire row be
highlighted red.

Is this possible?