Try this:

On Sheet1
A1: =IF(ISBLANK(Sheet2!G5),"You must enter a value in cell G5 on
Sheet2.",Sheet2!G5)

Is that what you're looking to do?

***********
Regards,
Ron


"Neil M" wrote:

On sheet 1 of my spreadsheet I have a cell whose value is the result of a
formula on sheet 2.
I don't want people to enter text or numbers here but I want to direct them
to sheet 2.
Is there a way to make cell A1 on sheet 1 have text that says "Blah blah
blah" until a value is entered on cell G5 on sheet 2?

Neil M