select Cell A3
and goto 'Data' Menu and choose 'Validation'.
under validation Settings/Criteria choose Allow as 'Custom'
and in the formula field below type in
=(A4<"Locked")

so this will not allow you to enter anything if A3 if A4 contains the text
'Locked'

is this is what you were looking for?

-kc
*click YES if this works


"Jerome" wrote:

How do I make an execl cell A3 read-only based on the value of cell A4?