+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting time conflicts

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,678

    Conditional formatting time conflicts

    Hi,

    I have a list which contains a list of activities including duration.

    I would like to have conditional formatting highlight any duplicates e.g. in my data set activities 1,3,4 and 6 should flag red as activity 4 runs over the other activities.

    In the attached example I have manually highlighted red the conflicts.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,094

    Re: Conditional formatting time conflicts

    This is a partial solution to your query in that it will only highlight offending lines, those that overlap previous entries and not those that are being overlapped. So in the case of your file it will highlight activity 6 as it overlaps the times for activities 1,3, and 4.
    I applied the conditional formatting to F12:I35, which omits the first activity in the table as that one can not run over any previous activity times. The CF formula is:
    Please Login or Register  to view this content.
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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 Formatting on a Time
    By cossie2k in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2015, 11:40 AM
  2. [SOLVED] Is there any way to time Conditional Formatting?
    By foxguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2013, 10:12 AM
  3. [SOLVED] Conditional Formatting Of Time
    By JJ Dimery in forum Excel General
    Replies: 0
    Last Post: 08-20-2012, 08:45 AM
  4. Excel 2007 : Internal Date/Time conflicts
    By Greenevo in forum Excel General
    Replies: 2
    Last Post: 03-20-2012, 05:56 PM
  5. Replies: 4
    Last Post: 01-11-2012, 07:59 PM
  6. How to stop conflicts with conditional formatting
    By Gooford in forum Excel General
    Replies: 5
    Last Post: 10-05-2009, 11:27 AM
  7. Marking Time/Date Conflicts
    By kukarooza in forum Excel General
    Replies: 1
    Last Post: 06-19-2008, 01:36 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