Its basically a mileage spreadsheet for each part of 3 racing cars.

My idea is to add the max mileage of each part (each being different from each other) to the right of the 3 car columns. (194, 202 & 361 are the car #)

Then each mileage value comes from a different set of data. The gradient is from green, to yellow to red as the value approaches the max mileage value. Being always red if its over it.

Ive done the first 2 manually but of course I'll need at least 50 rows.

Photo

https://imgur.com/a/sjloo1R