Hi,

How about using a formula-conditional formatting combination?

In F2, enter the formula,

=IF(E2="Yes","Provide detailed info in this cell","")

Also setup conditional formatting for F2 as outlined in my previous
response, but with the following formula

=AND(E2="Yes",F2="Provide detailed info in this cell")

F2 will remain empty and uncolored (?!) initially. If the user enters "Yes"
in E2, F2 will diplay "Provide detailed info in this cell" and the CF will
color the cell. When the user enters any info in F2, the CF restores the
cell to the default color.

PS: Please note that the formula (and conditional formatting) can execute
only once; when the user makes any entry in F2, the formula gets permanently
deleted (and overwritten), and as a consequence the CF gets incapacitated.

Regards,
B. R. Ramachandran






"nishapurohit" wrote:


Thanks to all that replied to my post!!

I was looking to make F2 field a required field, i.e <red

If E2 = "yes" then make F2 a required field.

I am going to email this spreadsheet to users, if the user select "yes"
to question asked in E column, I would like them to provide detailed
information in column F.

Does that make sense?

Thank you again for your help! this forum rocks!


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