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!!