Why, you can do that in CF Excel by selecting the whole row and use a
formula of

=$C$1=value



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"shantanu oak" wrote in message
ups.com...
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.