condition check for multiple words

[mwvirk]

hi

1- if a cell contains a specific text and if I want to change the cell format then it can be done for multiple words.
like in the attached picture, I want to see if the cell contains the word APL and then change the cell color. but is it possible for me can search multiple words using the single condition check?
I want to change the cell color if it contains 3 different words: APL ABC XYZ

2- if cell in range A contains only APL ABC XYZ then cell in range B show 100%

 

[awoohaw]

try this:

=IF(A8="","",IF((ISNUMBER(FIND("APL",A8))
+ISNUMBER(FIND("ABC",A8))
+ISNUMBER(FIND("XYZ",A8)))>0,0.075,0.15))

(edited)
Essentially, wrap the percentage formula in an IF statement that leaves the cell blank (or a value of "") if there is nothing in the comparison value.
(or only copy the formula down the rows that have data in column A.).

I could not tell from your xl2bb paste what column the cells with the text are in. I'll let you adjust that as well as the text. I've given you the essential formula(s) you just need to plug in the correct cell and text references.