Thanks BoniM. Just what I need.

"BoniM" wrote:

=IF(AND(A3="",A2="",A1<""),IF(A1="Warning:","","W arning:"),"")
Copy in cell below existing text in column A and then copy down... as data
is entered - Warning will move down. Since the formula will be replaced as
data is entered, if you delete data, you may need to repopulate with formula.


"Monk" wrote:

I would like certain text to appear (only once) in a cell in column A, three
rows after the last value is entered in that column.

i.e if the last value entered by a user appears in a3, I would like text
(say "Warning:") to appear in cell a6. If the user enters a value in a4, the
text will now appear in a7.

What would be the easiest way to achieve this?