I currently have a macro which searches for a word and if the row contains that word it deletes the row. What I want it to do however is highlight any rows containing that word however changing EntireRow.Delete to EntireRow.ColorIndex=6 doesn't seem to work. Am I using this incorrectly?