conditional formatting consecutive cells
 

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

conditional formatting consecutive cells
 

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

conditional formatting consecutive cells
 

Highlight cells:

in CF:

VvalueIs: less than 10

Select colour

OK

"chris" wrote:

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

conditional formatting consecutive cells
 

It's not clear from your question, but let's assume you want the CRITERIA
address to change

In your example, change

=$D$14<10

to

=$D14<10 [if you're formatting DOWN a column]



"chris" wrote:

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

conditional formatting consecutive cells
 

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

conditional formatting consecutive cells
 

Remind yourself of the difference between absolute and relative addressing.
Help will help.
--
David Biddulph

"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

conditional formatting consecutive cells
 

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

conditional formatting consecutive cells
 

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