You can set those cells up with conditional formatting, with a formula of
say =$A$1="abc" and set the pattern colour.

--

HTH

RP

"Jim Johnson" wrote in message
...
Can I automatically shade a range of cells when certain text is typed into
a
specific cell?