Help with formula

  • Thread starter Thread starter jzzman
  • Start date Start date
J

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 said:
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.]
 
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.
 
Then you will need a macro. cell AA6 cannot put data in e6 via cf or a
formula.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top