Conditional Format based on increments

[earwig999]

Hi,

is it possible to create a formula for a conditional format to recognise increments of £250,000 and highlight figures in the column which exceed them?

INCREMENTS of £250,000		E.g.
250000		234200
500000		310000
750000		400000
1000000		475000
1250000		501200
1500000		654000
1750000		748000
2000000		810000

<tbody>
</tbody>

I hope this makes some sense with the example table above.

 

[Joe4]

Assuming that you data is sorted in Ascending order, and that the first number appears in cell B2, then select cells B3 to the end, and enter this Conditional Formatting formula:

=INT($B3/250000) > INT($B2/250000)

and choose your desired formatting option.

 

[earwig999]

Assuming that you data is sorted in Ascending order, and that the first number appears in cell B2, then select cells B3 to the end, and enter this Conditional Formatting formula:

=INT($B3/250000) > INT($B2/250000)

and choose your desired formatting option.

Thank you and it works.... sort of

What I didn't say was that the figures go down as well as up on occasion and then the formula doesn't seem to work correctly.

£234,201
£297,171
£350,893
£533,307
£403,836
£583,518
£522,684
£789,871
£945,762
£876,035
£0
£884,436
£909,347
£868,714
£921,074
£1,130,828
£1,133,814

<colgroup><col></colgroup><tbody>
</tbody>

 

[Joe4]

What I didn't say was that the figures go down as well as up on occasion and then the formula doesn't seem to work correctly.

Yes, the devil is always in the details! That is why it is usually best to be as detailed as possible.

Perhaps this will work:

=INT($B3/250000) > INT(MAX($B2:B2)/250000)