dimanche 13 août 2017

Data Tracking in Excel

I'm looking for a way to write the following in Excel, but I always run in at least one trouble that makes the end result inconsistent. The user should only change the values in the B and C columns: Desired End Result

I'm making a database for Oil Changes in cars, each change must be every 10k Km. When the car reaches 9k Km, the corresponding B colum should color orange, and when it goes beyond the 10k, should be red, all of them are subject to the C column. The D and E columns should update automatically based on the values of B and C. Is this possible to do on Excel?

Aucun commentaire:

Enregistrer un commentaire