need help for one formula

2 Topics

Conditional formatting using formula IF and FIND
Dear Sir, Could you help me to create new formulas for Column A (Scope), thank you. Detail as below : if the string of cable name include "CBL" or "EXT" then will show CKT on Column A (Scope), otherwise will show "AVEX". Thank you so much for help.
Justin Hsu
Jul 31, 2018 Place Excel
1.3KViews
0likes
4Comments
Change cell to red color and return "mssing" of text regarding to two cell information
Dear Sir Could you help me, how to create one formulas in one cell Detail as attached file 1. I want to change cell color to red and return "missing" of text for cell of 7P, regarding to 7C is "null" && 7H is not "null" 2. I don't want to change color and show "missing" in cell of 7P, if 7C is "null" && 7H is "null" Thank you so much for help. Best Regards Justin Hsu Justin_hsu@amat.com
Justin Hsu
Jul 31, 2018 Place Excel
1.1KViews
0likes
2Comments