Hi Leaner7,

You can do this with conditional formatting. Do note that highlighting a whole row is wasteful and can adversely affect workbook performance if the whole row isn't otherwise being used.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]