I'd use column G:

=if(f2<"yes","","Please answer the question in column E!")

Format it in nice big bold red letters.

nishapurohit wrote:

I am sending a excel spreadsheet out to my end users to collect business
related data.

I'd like to make a cell value required, is this possible?

If answer to question asked in column F is "YES", make column E a
required. Can this be done using excel?

--
nishapurohit
------------------------------------------------------------------------
nishapurohit's Profile: http://www.excelforum.com/member.php...o&userid=30983
View this thread: http://www.excelforum.com/showthread...hreadid=506582

--

Dave Peterson