Macro for searching every cell in a particular column whether it ends with particular words defined in array : For instance, I want to see whether each cell from B10 till the end of the B colomn is ending with "@yahoo.com", "gmail.com", "rediff.com". If not then, it should color that particular cell