I need to apply conditional formatting to a column of cells based on the
values in other cells. ex. Cell A2 says $12,876.98 and cell C2 $14,987.98. I
want C2 to be green. The problem is I want to continue the same formatting
for the rest of the column "A3 compared to C3" and so on. If the value in "C"
column is lower I want it highlighted red and if the value is higher I want
it highlighted green.
The values change in each "A" and "C" column and I can only get the
conditional formatting to compare to A2
Any ideas?