Results 1 to 5 of 5

Calendar Year. Change colour of date if date between (inclusive) a date interval.

Threaded View

  1. #1
    Registered User
    Join Date
    11-26-2014
    Location
    Portugal
    MS-Off Ver
    Office 2013
    Posts
    3

    Calendar Year. Change colour of date if date between (inclusive) a date interval.

    I have an Excel file with two sheets. One with the full year calendar, and another with a set of records which are selected from a SQL Database table. I want the days in the calendar to change to green colour if that day exists in an inclusive interval of days which are in the second sheet. The initial date is in column D and the final date is in column E. Can someone explain me how to achieve that based on the file attached?

    The file is here:
    https://dl.dropboxusercontent.com/u/...C3%A9rias.xlsx

    or here:
    Mapa de Férias.xlsx
    Last edited by JMPovoa; 11-26-2014 at 12:26 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to compare date (including month and year) from a listed date to today's date
    By mhewitson15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 05:31 PM
  2. [SOLVED] Using SumProduct for dates inclusive of Year to Date, Month to date, Quarter to Date
    By cartica in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2014, 04:22 PM
  3. Replies: 3
    Last Post: 11-27-2013, 05:25 PM
  4. Replies: 11
    Last Post: 07-15-2012, 09:15 AM
  5. Replies: 3
    Last Post: 05-17-2011, 09:44 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1