Forum Discussion

Mario Rivera's avatar
Mario Rivera
Copper Contributor
Apr 19, 2017

Conditional Formatting (specific text That contains)

I have learned to use conditional formatting for one particualr item and use a color for it. Here is my issue. I deal with many emails and contantly have to check the list of emails employee list on ...
excel
Deleted's avatar
Deleted
Apr 19, 2017

Hello,

 

a way would be to add a helper column and check if the domain name matches a predefined list, you can also extend. Example:

 

=IFERROR(IF(MATCH(RIGHT(A2,LEN(A2)-FIND("@",A2)),$D$2:$D$6,0)>0,1,0),0)

If the domain name was found, the result is 1, else 0. The list is in $D$2:$D$6. Then, apply a conditional format by using the helper column.

 

I attached an example file. Hope, this helps.

 

Best,

Mourad

 

  • Mario Rivera's avatar
    Mario Rivera
    Copper Contributor
    Apr 20, 2017

    Mr. Mourad,

     

    Thank you for the quick reply. what you sent me makes sense, did not realize that the IF could be taken that far. I guess I still have much to learn in excel. I will then now take your formula and break it down so that I can understand every part of it. I did noticed the match formula in it which I am very familiar with it, but the rest of the formula is greek to me. Again thank you so much for the help, now its time to learn from what you sent me.

     

    Sincerely,

     

    Mario

Resources