+ Reply to Thread
Results 1 to 3 of 3

Conditional Formating - Betwen time Column

  1. #1
    Registered User
    Join Date
    08-06-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    15

    Conditional Formating - Betwen time Column

    Hello Everyone,

    First of all thank you for helping each other and having passion for excel.

    Today I am willing to find out solution for highlighting each cell which falls under shift time of each employee through conditional formatting.

    So if employee is working 8:00 to 4:30 than each cell till 4:30 should become green.


    For reference I am also attaching Excel file to see what I am talking about.

    Hopping to hear back soon. Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Conditional Formating - Betwen time Column

    Please select D4:CU67 Press Alt H L N > use a formula

    =($B4<=D$3)+(--SUBSTITUTE($C4,"~","")>=D$3)-(--SUBSTITUTE($C4,"~","")>$B4)

    > format > fill > change color > OK

  3. #3
    Registered User
    Join Date
    08-06-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    15

    Re: Conditional Formating - Betwen time Column

    OMG,

    Thank You so much. This worked for me.

    Thanks a lot.

+ 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. [SOLVED] Conditional Formating Time help
    By Beastwood in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-21-2013, 11:44 AM
  2. Conditional formating based on the time and date
    By kricks99 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-02-2013, 09:42 PM
  3. Conditional Formating - using time HH:MM:SS AM/PM
    By OldTownComputers in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-01-2013, 07:45 PM
  4. Time Formating for Conditional Formating
    By harryhoudini66 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-14-2013, 09:33 AM
  5. Conditional Formating using time
    By David_S_Walker in forum Excel General
    Replies: 5
    Last Post: 06-16-2011, 08:34 AM
  6. Conditional Formating - using time h:mm AM
    By Foxcan in forum Excel General
    Replies: 1
    Last Post: 06-23-2009, 09:30 AM
  7. Calculating Difference Betwen Time Frames
    By Vladmir1111 in forum Excel General
    Replies: 2
    Last Post: 01-16-2009, 11:48 PM
  8. Help with Conditional Formating Time
    By jonhunt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-13-2006, 04:10 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