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