Results 1 to 3 of 3

Thread: Excel spreadshheet for our vehicle maintenance

  1. #1
    Silver Member
    Join Date
    Oct 2011
    Location
    johannesburg
    Posts
    212
    Thanks
    2
    Thanked 9 Times in 9 Posts

    Excel spreadshheet for our vehicle maintenance

    Hi,
    I would like to make up an excel spreadshheet for our vehicle maintenance. I need to easly manage and know next service due date based on kilometres travelled.
    I would like excel to high light the next due service at least about 2,000km before next service due.

    Is this possible? Any help would be greatly appreciated

  2. #2
    Email problem Mike Simmonds's Avatar
    Join Date
    Aug 2011
    Location
    Bronkhorstspruit
    Posts
    76
    Thanks
    15
    Thanked 29 Times in 20 Posts
    Which version of excel are you using? If you are using Excel 2010 then have 3 columns (current km's, service km's, difference). Then use conditional formatting and create a new rule on the difference column with a formula like =c2<2001 and set the format to fill with whatever color you like when the difference is 2000km or less. Once you have tested the formula on the first cell just drag it to populate the balance of the cells. Just remember to save you Excel Spreadsheet whenever you change any numbers and life should be simple.

  3. #3
    Silver Member
    Join Date
    Oct 2011
    Location
    johannesburg
    Posts
    212
    Thanks
    2
    Thanked 9 Times in 9 Posts
    Hi Mike,
    Great, thanks

Similar Threads

  1. [Question] Chip Fryer Maintenance
    By AmithS in forum Food Industry Forum
    Replies: 4
    Last Post: 01-Dec-10, 09:09 PM
  2. Do your electric fence maintenance now!!!
    By garthu in forum Technology Forum
    Replies: 9
    Last Post: 14-Oct-10, 10:38 AM
  3. electrical maintenance contract
    By murdock in forum Electrical Contracting Industry Forum
    Replies: 4
    Last Post: 27-May-10, 10:00 AM
  4. Maintenance is not being done.
    By Dave A in forum Electrical Contracting Industry Forum
    Replies: 1
    Last Post: 12-Jun-08, 09:26 PM
  5. Planned server maintenance
    By Dave A in forum News Archive
    Replies: 3
    Last Post: 01-Feb-07, 06:19 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •