Try this:

Select F2 Format Conditional Formatting
Formula is: =IF(E2="Yes",TRUE)
Format as required, Ok out.

Does this help?


"nishapurohit"
wrote in message
news:nishapurohit.22gr9z_1138651204.6458@excelforu m-nospam.com...

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=506498