How can I change the comparison formula for each cell the condition is
applied to. Example: B2<(E2)+(F2), I need to copy the condition to other
cells but to change relative to the cell location, B3<(E3)+(F3) and so on
down the column? I have tried this with and without the $ anchor, as well as
with and without the cell reference in the formula (B2 or B3 as used here)
but it does not seem to work. At one point the formula would change when
copied to other cells, but it was comparing the previous row's cells
[B4<(E3)+(F3)] and I don't know why or how this happened. Ideas?