Past this formula in B2

=IF(A2="","missing","")


write something in A2 and then delete it.


"nada" wrote:

hello,
how could i make any blank cell in a particular range in a worksheet
displays certain word if it is dataless??