Help with formula

[jzzman]

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]

BTW,

I didn't mention my formula is not in cell E6 I need it to be in cell AA6.

[Allllen]

Sure

=IF(C6="yes","complete","whatever you want it to say if C6 is not yes")

--
Reply by thread only
thanks
Allllen


"jzzman" wrote:

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

[jzzman]

Thanks for the reply.

[Don Guillett]

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

--
Don Guillett
SalesAid Software
[email protected]
"jzzman" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[David Biddulph]

"jzzman" <[email protected]> wrote in
message news:[email protected]...
>
> 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",????

It's not conditional formatting, as you are altering the content of the
cell, not its format.
In E6, put the formula
=IF(C6="yes","complete","not complete")
[You can replace "not complete" by whatever you want in E6 if C6 is NOT
"yes". Put "" if you want it to be blank in that case.]
--
David Biddulph

[Allllen]

Also, conditional formatting will only help you change the formatting of a
cell, not the text in it. You have to put your formula in the cell itself.
--
Reply by thread only
thanks
Allllen


"jzzman" wrote:

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

[Don Guillett]

Then you will need a macro. cell AA6 cannot put data in e6 via cf or a
formula.

--
Don Guillett
SalesAid Software
[email protected]
"jzzman" <[email protected]> wrote in
message news:[email protected]...
>
> BTW,
>
> I didn't mention my formula is not in cell E6 I need it to be in cell
> AA6.
>
>
> --
> jzzman
>
>
> ------------------------------------------------------------------------
> jzzman's Profile:
> http://www.excelforum.com/member.php...o&userid=24838
> View this thread: http://www.excelforum.com/showthread...hreadid=549193
>