conditional formatting

[nishapurohit]

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,

Nish

 

[pinmaster]

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