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?