have I understood your question???

in B13 type
=IF(L2<0,$P$1,"")
copy B13 down and right upto J21

see whether you get what you want

============================
gocats wrote in message
...
If any cell (with value 0) in the range L2:T10 is selected I wish to
update
the corresponding cell in the range B13:J21 with the value in $P$1.