software

Thanks to all that replied to my post!!

I was looking to make F2 field a required field, i.e lt;redgt;

If E2 = quot;yesquot; then make F2 a required field.

I am going to email this spreadsheet to users, if the user select quot;yesquot;
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: www.excelforum.com/member.php...oamp;userid=30983
View this thread: www.excelforum.com/showthread...hreadid=506552Sure. Click on F2. Format--gt;Conditional Formatting, Formula is:
=IF(E2)=quot;yesquot;
Tell it to be red fill....
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;nishapurohitquot; gt;
wrote in message
news:nishapurohit.22gw4y_1138657504.0146@excelforu m-nospam.com...
gt;
gt; Thanks to all that replied to my post!!
gt;
gt; I was looking to make F2 field a required field, i.e lt;redgt;
gt;
gt; If E2 = quot;yesquot; then make F2 a required field.
gt;
gt; I am going to email this spreadsheet to users, if the user select quot;yesquot;
gt; to question asked in E column, I would like them to provide detailed
gt; information in column F.
gt;
gt; Does that make sense?
gt;
gt; Thank you again for your help! this forum rocks!
gt;
gt;
gt; --
gt; nishapurohit
gt; ------------------------------------------------------------------------
gt; nishapurohit's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30983
gt; View this thread: www.excelforum.com/showthread...hreadid=506552
gt;
No need for the IF, just use

=E2=quot;yesquot;

as that resolves to TRUE or FALSE

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Anne Troyquot; gt; wrote in message
...
gt; Sure. Click on F2. Format--gt;Conditional Formatting, Formula is:
gt; =IF(E2)=quot;yesquot;
gt; Tell it to be red fill....
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;nishapurohitquot; gt;
gt; wrote in message
gt; news:nishapurohit.22gw4y_1138657504.0146@excelforu m-nospam.com...
gt; gt;
gt; gt; Thanks to all that replied to my post!!
gt; gt;
gt; gt; I was looking to make F2 field a required field, i.e lt;redgt;
gt; gt;
gt; gt; If E2 = quot;yesquot; then make F2 a required field.
gt; gt;
gt; gt; I am going to email this spreadsheet to users, if the user select quot;yesquot;
gt; gt; to question asked in E column, I would like them to provide detailed
gt; gt; information in column F.
gt; gt;
gt; gt; Does that make sense?
gt; gt;
gt; gt; Thank you again for your help! this forum rocks!
gt; gt;
gt; gt;
gt; gt; --
gt; gt; nishapurohit
gt; gt; ------------------------------------------------------------------------
gt; gt; nishapurohit's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=30983
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=506552
gt; gt;
gt;
gt;
Thanks, Bob.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Bob Phillipsquot; gt; wrote in message
...
gt; No need for the IF, just use
gt;
gt; =E2=quot;yesquot;
gt;
gt; as that resolves to TRUE or FALSE
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;Anne Troyquot; gt; wrote in message
gt; ...
gt;gt; Sure. Click on F2. Format--gt;Conditional Formatting, Formula is:
gt;gt; =IF(E2)=quot;yesquot;
gt;gt; Tell it to be red fill....
gt;gt; ************
gt;gt; Hope it helps!
gt;gt; Anne Troy
gt;gt; www.OfficeArticles.com
gt;gt;
gt;gt; quot;nishapurohitquot;
gt;gt; gt;
gt;gt; wrote in message
gt;gt; news:nishapurohit.22gw4y_1138657504.0146@excelforu m-nospam.com...
gt;gt; gt;
gt;gt; gt; Thanks to all that replied to my post!!
gt;gt; gt;
gt;gt; gt; I was looking to make F2 field a required field, i.e lt;redgt;
gt;gt; gt;
gt;gt; gt; If E2 = quot;yesquot; then make F2 a required field.
gt;gt; gt;
gt;gt; gt; I am going to email this spreadsheet to users, if the user select quot;yesquot;
gt;gt; gt; to question asked in E column, I would like them to provide detailed
gt;gt; gt; information in column F.
gt;gt; gt;
gt;gt; gt; Does that make sense?
gt;gt; gt;
gt;gt; gt; Thank you again for your help! this forum rocks!
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; nishapurohit
gt;gt; gt; ------------------------------------------------------------------------
gt;gt; gt; nishapurohit's Profile:
gt;gt; gt; www.excelforum.com/member.php...oamp;userid=30983
gt;gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=506552
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;
You know the pleasure is mine Ma'am,

Bob

quot;Anne Troyquot; gt; wrote in message
...
gt; Thanks, Bob.
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;Bob Phillipsquot; gt; wrote in message
gt; ...
gt; gt; No need for the IF, just use
gt; gt;
gt; gt; =E2=quot;yesquot;
gt; gt;
gt; gt; as that resolves to TRUE or FALSE
gt; gt;
gt; gt; --
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from the email address if mailing direct)
gt; gt;
gt; gt; quot;Anne Troyquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; Sure. Click on F2. Format--gt;Conditional Formatting, Formula is:
gt; gt;gt; =IF(E2)=quot;yesquot;
gt; gt;gt; Tell it to be red fill....
gt; gt;gt; ************
gt; gt;gt; Hope it helps!
gt; gt;gt; Anne Troy
gt; gt;gt; www.OfficeArticles.com
gt; gt;gt;
gt; gt;gt; quot;nishapurohitquot;
gt; gt;gt; gt;
gt; gt;gt; wrote in message
gt; gt;gt; news:nishapurohit.22gw4y_1138657504.0146@excelforu m-nospam.com...
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks to all that replied to my post!!
gt; gt;gt; gt;
gt; gt;gt; gt; I was looking to make F2 field a required field, i.e lt;redgt;
gt; gt;gt; gt;
gt; gt;gt; gt; If E2 = quot;yesquot; then make F2 a required field.
gt; gt;gt; gt;
gt; gt;gt; gt; I am going to email this spreadsheet to users, if the user select
quot;yesquot;
gt; gt;gt; gt; to question asked in E column, I would like them to provide detailed
gt; gt;gt; gt; information in column F.
gt; gt;gt; gt;
gt; gt;gt; gt; Does that make sense?
gt; gt;gt; gt;
gt; gt;gt; gt; Thank you again for your help! this forum rocks!
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt; nishapurohit
gt; gt;gt;
gt; ------------------------------------------------------------------------
gt; gt;gt; gt; nishapurohit's Profile:
gt; gt;gt; gt; www.excelforum.com/member.php...oamp;userid=30983
gt; gt;gt; gt; View this thread:
gt; gt; www.excelforum.com/showthread...hreadid=506552
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;