earwig999
New Member
- Joined
- Jan 11, 2013
- Messages
- 42
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?
<tbody>
</tbody>
I hope this makes some sense with the example table above.
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.