I guess I wasnt specific enough. Lets imagine pasting data that is 10 columns
wide by 1200 rows long. After I paste this data, the respective rows would
automatically color themselves according to what was in column "D" of the
respective row. So what I need is instruction on creating a formula for the
whole worksheet. I do not wish to select a row and then conditionally format
it. I want the software to perform it for me.