I cannot figure out how to get a row to conditionally format, individual
cells to turn red when less than the cell above them, without doing each cell
individually. When I try to either select them all or drag or copy the
formatting to the row, I end up with each individual cell turning red if it
is less than the first cell in the row above, not the cell directly above.
Does anyone know how to quickly do this formatting?