Results 1 to 3 of 3

Conditional Formatting - coloring cells between dates

Threaded View

  1. #1
    Registered User
    Join Date
    03-10-2013
    Location
    Mukilteo, WA
    MS-Off Ver
    Excel 2007
    Posts
    29

    Conditional Formatting - coloring cells between dates

    I have attached a file to this post to help explain my problem.

    In Column A I have 5 tasks and in columns B and C I have start and end dates for those tasks.
    In Columns D through K I have a schedule matrix.
    I'd like Excel to color in the cells under the date range for each Task.

    I've manually colored in cells D2 and E2 to show how I'd like the conditional formatting to look like.

    Can anyone please help me set up the function and the conditional formatting for this?

    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. [SOLVED] Conditional Formatting - Coloring Cells based on Values
    By desibabuji in forum Excel General
    Replies: 8
    Last Post: 11-22-2013, 12:31 PM
  2. Replies: 8
    Last Post: 03-14-2013, 04:40 PM
  3. [SOLVED] Conditional formatting - coloring cells across array if value exists in a list
    By mudder12 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 12-05-2012, 12:38 PM
  4. Conditional Formatting - Coloring Cells in Rows according Text in it
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2012, 01:28 AM
  5. Conditional formatting coloring dates
    By Capslock in forum Excel General
    Replies: 2
    Last Post: 09-27-2007, 12:19 PM

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