conditional formatting consecutive cells

C

chris

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
 
P

PCLIVE

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
 
D

Duke Carey

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]
 
D

David Biddulph

Remind yourself of the difference between absolute and relative addressing.
Help will help.
 
P

PCLIVE

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.
 
C

chris

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