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.