Results 1 to 4 of 4

Conditional Formatting based on Dates

Threaded View

  1. #1
    Registered User
    Join Date
    04-12-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    12

    Question Conditional Formatting based on Dates

    Hello,

    I am trying to develop a timeline that colours in cells under each month based on a variety of date criteria.

    For example, there is a Build Period that runs from 12/01/16 to 13/04/2016. I therefore want the cells under 01/2016, 02/2016, 03/2016 and 04/2016 to be coloured in (i.e. there is activity in those months). There is also a category which is just an event ("Launch") which I can work out how to do (using MONTH(XX)=MONTH(XX)). It's the periods that I'm struggling with.

    It probably makes more sense by looking at the attached. I have manually coloured the timeline but I would like to try and automate it, perhaps by using conditional formatting, by comparing the dates along the top to the dates to the left.

    I have tried a variety of > < = etc. but can't get the right result.

    Any help hugely appreciated.

    Thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. conditional formatting based on dates
    By hiswillbedun in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-10-2015, 11:52 AM
  2. [SOLVED] Conditional Formatting based on dates
    By Vladcfc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-28-2013, 05:15 PM
  3. [SOLVED] Conditional Formatting based on dates
    By olivetwist in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-15-2013, 02:12 PM
  4. Conditional Formatting based on dates
    By colinmonaghan1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-12-2013, 11:28 AM
  5. Conditional Formatting based on dates (2)
    By rz6657 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2013, 03:17 PM
  6. [SOLVED] Conditional Formatting based on dates
    By radiozed in forum Excel General
    Replies: 9
    Last Post: 01-24-2013, 04:08 PM
  7. Conditional Formatting Based Upon Various Dates
    By Zaraf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-08-2008, 11:56 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