I am trying to not allow any values to be typed in a row if the last column
in that row has the word "COMPLETED" in it. the word completed is linked to
another sheet but it does display the exact word on this sheet with a =cell
formula between sheets.