conditional formatting consecutive cells

[Guest]

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

 

[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

 

[Guest]

Highlight cells:

in CF:

VvalueIs: less than 10

Select colour

OK

 

[Guest]

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]

 

[Guest]

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

 

[David Biddulph]

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

 

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

 

[Guest]

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