I tried that, but it keeps referring the the original cell; ie:d14


"PCLIVE" wrote:

Yes. Copying conditional formatting should copy and adjust the same as
copying a formula.
Give it a try. You can set your conditional formatting in one cell and then
copy the cell. Use Paste Special and Paste Formats to apply to other cells.

Good luck,
Paul


"chris" wrote in message
...
I'm trying to apply conditional formatting to a range of cells. I want the
formatting to work the same as if I was copying formulas, where the
consecutive cells change. Is it possible to do the same with formatting?
=$D$14<10
=$D$15<10