CF cannot do this. You do need a formula
in e6
=if(c6="Yes","Complete","")

--
Don Guillett
SalesAid Software

"jzzman" wrote in
message ...

I have searched for this, but can't find it. I am trying to make a
formula in conditional formatting to place text in cell E6 based on an
IF statement based on text in cell C6. So, if cell C6 has the word
"yes" typed in it, then text "complete" will be placed in cell E6. Can
you guys help me with how this formula would be written? I have
=IF(c6="yes",????


Thanks,


--
jzzman


------------------------------------------------------------------------
jzzman's Profile:
http://www.excelforum.com/member.php...o&userid=24838
View this thread: http://www.excelforum.com/showthread...hreadid=549193