Text to appear three rows after last blank cell in column

[Monk]

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?

 

[BoniM]

=IF(AND(A3="",A2="",A1<>""),IF(A1="Warning:","","Warning:"),"")
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.

 

[Pete_UK]

A formula cannot "push" a value to another cell, so you would have to
use a macro to do this.

Pete

 

[Monk]

Thanks BoniM. Just what I need.

=IF(AND(A3="",A2="",A1<>""),IF(A1="Warning:","","Warning:"),"")
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.