Excel due and overdue date colours

Excel Discussion in 'Microsoft Office' started by hillbilee001, Sep 6, 2018.

  1. hillbilee001

    hillbilee001

    Joined:
    Sep 6, 2018
    Likes Received:
    1
    I have a few cars in a garage I look after maintenance on , and want to create a spreadsheet that automatically tells me when a date is overdue.
    I have used conditional formatting to change a date when its due in 30 days to yellow, and over the date to red.
    wjt I want to do is add another column to automatically change to say DUE or OVERDUE etc

    thanks
     
    hillbilee001, Sep 6, 2018
    #1
    Abraham Andres Luna likes this.
    1. Advertisements

  2. hillbilee001

    Abraham Andres Luna

    Joined:
    Mar 14, 2018
    Likes Received:
    90
    Location:
    Spring Hill, FL 34608
    Abraham Andres Luna, Sep 6, 2018
    #2
    Becky likes this.
    1. Advertisements

  3. hillbilee001

    hillbilee001

    Joined:
    Sep 6, 2018
    Likes Received:
    1
    great thanks done it - all sorted.
     
    hillbilee001, Sep 7, 2018
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.