Hi Experts out there,

I would like to seek for your help. I am trying to write
some codes that will update the entire row color when
certain word is type in a particular cell.

For Example, I am using Column A as the status check.
WHen I type "Done" in the the cell A2, then I want the
entire row 2 to be highlighted in grey.

How do I go about doing this?

MANY THANKS IN ADVANCE...

LSB