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?

Formula Is =$A2<$A1


"anthony127112" wrote:

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?

If the range you are trying to format starts at A2, CF/ Cell Value Is/ less
than/ =$A1
--
David Biddulph

"anthony127112" wrote in message
...
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?

Sorry. I misread your question. You *don't* want the absolute reference
for the column.

If the range you are trying to format starts at A2, CF/ Cell Value Is/ less
than/ =A1
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
If the range you are trying to format starts at A2, CF/ Cell Value Is/
less than/ =$A1
--
David Biddulph

"anthony127112" wrote in message
...
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?

But won't that format B2 if A2 is less than A1?
What I think the OP wants is for B2 to be formatted if B2 is less than B1?

[But thanks for posting that anyway, because it made me re-read the OP and
revise my original answer.]
--
David Biddulph

"Teethless mama" wrote in message
...
Formula Is =$A2<$A1


"anthony127112" wrote:

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?