I have a column of ascending numbers. I want to mark every cell in this column that is larger or equal to an integer multiple of a predetermined value, e.g. 300 in the example image.

I tried using the MOD function but it did not allow me to solve this task. The mod function generates a ziz-zag waveform (graphically speaking) and I understand that in the general case I need to find the local minimum to select the right cell, but I am not quite sure how to do that (the numbers in my data aren't necessarily integers, so MOD(x, 300) is almost never equal to zero).

(The values actually will be the running hours of a motor and some fixed value is the scheduled maintenance work on it)

`=INT(B1/300)`

or`=QUOTIENT(B1,300)`

. Now to flag only the first number which is larger than n*300 as in your example,`=QUOTIENT(B2,300)<>QUOTIENT(B1,300)`

(starting in cell C2). You can also use this as a custom conditional formatting formula (remember to use relative refs "B2" not absolute "$B$2").