software

Hello!!

I need help with adding conditional formatting in excel (2003) file.

I'd like the formula to be something like this -

IF Cell E2 = Yes; make Cell F2 required cell lt;in redgt;

If this doable? Please help!!!!!!

Thank you,

Nisha--
nishapurohit
------------------------------------------------------------------------
nishapurohit's Profile: www.excelforum.com/member.php...oamp;userid=30983
View this thread: www.excelforum.com/showthread...hreadid=506504Yes.....select F2 then go to Format/Conditional Formatting, then select
quot;formula isquot; from the drop down list and type =E2=quot;yesquot;, next click on Format
and format as desired.

HTH
JG

quot;nishapurohitquot; wrote:

gt;
gt; Hello!!
gt;
gt; I need help with adding conditional formatting in excel (2003) file.
gt;
gt; I'd like the formula to be something like this -
gt;
gt; IF Cell E2 = Yes; make Cell F2 required cell lt;in redgt;
gt;
gt; If this doable? Please help!!!!!!
gt;
gt; Thank you,
gt;
gt; Nisha
gt;
gt;
gt; --
gt; nishapurohit
gt; ------------------------------------------------------------------------
gt; nishapurohit's Profile: www.excelforum.com/member.php...oamp;userid=30983
gt; View this thread: www.excelforum.com/showthread...hreadid=506504
gt;
gt;