Ok, think I better understand what you are after. Have changed the code to search all of Column B for any time the word inactieve is included within a cell and it will then carry out the formatting required.Werkmap1 RevB.xlsm