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