conditional formatting
 

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 <in red

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

Thank you,

Nisha


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

conditional formatting
 

Yes.....select F2 then go to Format/Conditional Formatting, then select
"formula is" from the drop down list and type =E2="yes", next click on Format
and format as desired.

HTH
JG

"nishapurohit" wrote:


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 <in red

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

Thank you,

Nisha


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