Conditional formating on an entire row based on contents in one row.

I have a table that I want to color the font red in an entire row IF the contents in Row N# contains the word EMPTY.

I would like to do this in VBA, thoughts?