I need a snippet of code that will check each cell in column K for the value
"Y" - if there's a Y in the cell, I want to format that entire row as locked
and then move down to check the next cell etc

Can anyone help me with the syntax please?