Hi,

I have a spreadsheet with data in two worksheets. I need to compare the data
in each cell of column A in worksheet A to the data in each cell of column A
of worksheet B. If the value of a cell in worksheet A is greater, I need the
cell to be colored green. If the value is less, I need it to be coded red.
There is the same number of rows in both columns.

I have tried copying the column from worksheet B into worksheet A, but this
doesn't help much. The problem is that when I do the normal greater/less than
conditional formating, I can't copy and paste the formula down the column
because it will only look at the value of the first cell that I entered. I
don't know how to do codes or anything, so I don't know how to fix this.