I want to use conditional formatting in a macro in such a way that the
entire row will be colored in Red instead of the single cell that
contains the specific word. Please guide.