+ Reply to Thread
Results 1 to 5 of 5

Conditionl Formating to highlight time slots between start and Finish time.

  1. #1
    Registered User
    Join Date
    01-25-2017
    Location
    Australia
    MS-Off Ver
    10.0.0
    Posts
    2

    Question Conditionl Formating to highlight time slots between start and Finish time.

    Hello,

    This question has probably been asked before, I have a booking schedule with time slots, I would like a selection of cells to highlight between the start and end time. I have attached an example of what I am looking to do. currently i am manually highlighting the time slots, i would like it to auto fill when i enter the times.

    Please help?

    Thanks in advanced
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,898

    Re: Conditionl Formating to highlight time slots between start and Finish time.

    Hi, welcome to the forum

    1. highlight the range you want to apply the conditional formatting to
    2. on the home tab, styles, select CF
    3. select new rule, select use formula
    4. enter =AND(D$3>=$B4,D$3<=$C4)...format fill as needed
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,898

    Re: Conditionl Formating to highlight time slots between start and Finish time.

    Hi, welcome to the forum

    1. highlight the range you want to apply the conditional formatting to
    2. on the home tab, styles, select CF
    3. select new rule, select use formula
    4. enter =AND(D$3>=$B4,D$3<=$C4)...format fill as needed

  4. #4
    Registered User
    Join Date
    01-25-2017
    Location
    Australia
    MS-Off Ver
    10.0.0
    Posts
    2

    Thumbs up Re: Conditionl Formating to highlight time slots between start and Finish time.

    Thank you FDibbins! You're a champion Solved
    Last edited by excelrooky; 01-25-2017 at 02:35 AM.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,898

    Re: Conditionl Formating to highlight time slots between start and Finish time.

    happy to help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 12
    Last Post: 01-25-2016, 10:53 AM
  2. Replies: 0
    Last Post: 11-17-2013, 10:21 AM
  3. Calculate finish time given start time, working hours and job duration
    By swanseaexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2012, 03:00 PM
  4. Ready Time, Start Time, Finish Time by user
    By teguigala in forum Excel General
    Replies: 3
    Last Post: 02-15-2012, 03:34 PM
  5. Replies: 6
    Last Post: 11-29-2011, 09:12 AM
  6. [SOLVED] how to calculate time start &amp;amp; time finish in quarter hour
    By Peter Wu in forum Excel General
    Replies: 3
    Last Post: 06-06-2006, 08:10 PM
  7. [SOLVED] template or formula for start time -finish time -total hours ple
    By cc in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-27-2006, 01:10 PM

Tags for this Thread

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