I have 10 trucks that needs a components replacement for every cummaltive 60000km. I have my trucks in column A. Amd cumulative kms by month in the rest of the columns. The trucks needs a components replacement at every cummaltive 60000km. So it becomes 120000kms for the the service and 180000kms for one after that.I want to use a formulae to highlight in which month would we need a component replacement based on every 60000kms but it’s cummaltive requiment of 60000kms . What formulaes/conditional formatting or other formulae can I use in my cummalive monthly information per truck to flag or highlight the month that we reach the cummaltive 60000kms requirements?

​I have 10 trucks that needs a components replacement for every cummaltive 60000km. I have my trucks in column A. Amd cumulative kms by month in the rest of the columns. The trucks needs a components replacement at every cummaltive 60000km. So it becomes 120000kms for the the service and 180000kms for one after that.I want to use a formulae to highlight in which month would we need a component replacement based on every 60000kms but it’s cummaltive requiment of 60000kms . What formulaes/conditional formatting or other formulae can I use in my cummalive monthly information per truck to flag or highlight the month that we reach the cummaltive 60000kms requirements?  Read More

​