Text to appear three rows after last blank cell in column
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?
|