Excellent advice!
I'm just starting to learn the VBA basics, so I appreciate t
he kick start.

"PCLIVE" wrote:

The "$" makes the formula stay constant when copying...so it won't change.
If you want the row and Column reference to adjust when copying, then remove
the dollar signs.


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