How to change text in a cell based on another cell

Closed

Negative459 Posts 1 Registration date Tuesday November 26, 2013 Status Member Last seen November 26, 2013 - Nov 26, 2013 at 02:51 PM
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 - Nov 27, 2013 at 05:52 AM

I am working on an asset tracking sheet and I want to use conditional formatting to change the text in one cell based on the text in another.

Reference: Currently the data in column F shows different available asset types. If that particular asset has a limited quantity, denoted by "PP" in that cell's text, I have a formula in the next cell over (column G) to change the color of the text in the G cell to orange. =ISNUMBER(SEARCH("PP",F5))=TRUE.

Now I also want to add a formula which will change the text in the G cell to "N/A" (not orange) instead if "PP" is not found in the F cel. How can I do this? Thanks!

How to change text in a cell based on another cell
If cell contains text then return value multiple conditions ✓ - Excel Forum
Conditional formatting if cell contains text - Excel Forum
How to change close friends story to public - Instagram Forum
How to change language in kmplayer - Guide
If cell contains date then return value ✓ - Office Software Forum

1 response

Answer 1 / 1

sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
Nov 27, 2013 at 05:52 AM

Hi

Try The below formula in G5

=IF(ISNUMBER(SEARCH("PP",F5)),"","N/A")

Hope it will solve other wise please inform

Thanks

Patnaik

Similar discussions

help me to add particular cells

How do I change a base location on Instagram?

How to use conditional format based on text?

If a cell contains any text then add a value

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!