Help with a blank cell warning
 

I am trying, quite unsuccessfully I might add, to have a warning pop up
if a cell is left blank, but only if there is any typing in another
specific cell. Example:
--------------------------------------------------------------------------------------
Describe the information given:
________________________________________________
Was this useful?
Yes: __ No: __

-Please select yes or no-
--------------------------------------------------------------------------------------
In this example, had there been a response given to the question, but
with no yes or no response, the -Please select... -message would appear
below the yes/no line.

Thanks


--
Maxemily

Help with a blank cell warning
 

Maxemily --

If you want some language to appear if there's an entry in cell A1, try:

=if(A1<"","some language","")


"Maxemily" wrote:


I am trying, quite unsuccessfully I might add, to have a warning pop up
if a cell is left blank, but only if there is any typing in another
specific cell. Example:
--------------------------------------------------------------------------------------
Describe the information given:
________________________________________________
Was this useful?
Yes: __ No: __

-Please select yes or no-
--------------------------------------------------------------------------------------
In this example, had there been a response given to the question, but
with no yes or no response, the -Please select... -message would appear
below the yes/no line.

Thanks


--
Maxemily