If you use PC's method (subtly different from Jason's), selecting all the
rows and then setting the condition will work.

--

Vasant

"Bruise" wrote in message
...
Thank you for the help on setting this up. My only question now is this:
How can I set this Conditional Formatting up for several rows without having
to do it individually for each row? I tried selecting them all, but it
reverts to the absolute formula and reflects entries in that cell only.

Help!!