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
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!
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!
Related:
- How to change text in a cell based on another cell
- How to change language in kmplayer - Guide
- How to change free fire google account to another google account - Guide
- How to change dinosaur in chrome - Guide
- How to change time in whatsapp - Guide
- How to change language in idm - Guide
1 response
sgmpatnaik
Posts
52
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
45
Nov 27, 2013 at 05:52 AM
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
Try The below formula in G5
=IF(ISNUMBER(SEARCH("PP",F5)),"","N/A")
Hope it will solve other wise please inform
Thanks
Patnaik