High lightng dates in future, today and past

Excel Discussion in 'Microsoft Office' started by TTink, Apr 18, 2017.

  1. TTink


    Apr 18, 2017
    Likes Received:
    Just joined so hopefully someone can help. I am trying to highlight in different colours whole columns in excel, date between tomorrow and 14 days ahead(green) today date (orange), dates frm yesterday to 14 days just gone(blue), dates from 14 days and forever in the past (red) blank cells to remain blank. Having trouble and not a wizz kid on computers. Can anyone help ???? It would be appreciated. Thanks
    TTink, Apr 18, 2017
    1. Advertisements

  2. TTink

    Becky Webmistress Administrator

    Mar 25, 2003
    Likes Received:
    Welcome to the forum, and sorry for the late reply :)

    You can use Conditional Formatting for that. Highlight the column(s) you want to format, then go to Conditional Formatting (it's within the Home tab). You could then choose 'Highlight Cells Rules' and then choose which option you want. You will have to apply one new rule for each different requirement, so do one at a time.

    This guide from Microsoft may be of use too: https://support.office.com/en-gb/ar...32a1af?ui=en-US&rs=en-GB&ad=GB#__toc304825863

    Let me know if you run into any trouble and I'll help out.
    Becky, Apr 20, 2017
    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.