+ Reply to Thread
Results 1 to 2 of 2

Look for overlapping events and highlight cells

  1. #1
    Registered User
    Join Date
    10-21-2022
    Location
    Greece
    MS-Off Ver
    2016
    Posts
    5

    Look for overlapping events and highlight cells

    My sheet contains a list of planned events.

    In column A i have the start time, in column B i have the stop time and in column C i have the status for each event. Additionally, in column D i have the events titles.

    I want to check if any events whose status has been set as "pending" overlap.

    If two or more events overlap i want to add a red background to the cells A, B, C in the rows that contain information for the overlapping events.

    For example, if the events in row 7 and 13 overlap at all (which means that the dates in A7 and/or B7 are between the dates of A13 and B13) and both C7 and C13 are "pending" i want to add a red background to the cells A7,B7,C7,A13,B13,C13.

    I have already made a few attempts but i couldn't get them to work as they either highlight the wrong cells or the macro takes forever to execute.

    It would also like to have a msgbox saying that the events [Insert title from D7] and [Insert title from D13] overlap.

    Thank you for your time and patience.

    PS: I have to insist on using macros instead of conditional formatting, because this is a document other people use at work and i don't want them messing up the formatting rules when they copy cells. I have actually made a great amount of progress with VBA coding for this spreadsheet and this is the last thing i want to add to the document.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,088

    Re: Look for overlapping events and highlight cells

    What about an Excel sample file to help to prepare macros ...?
    - Battle without fear gives no glory - Just try

+ 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. highlight overlapping /intersecting time periods with several conditions
    By simoncello in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-25-2022, 11:09 AM
  2. [SOLVED] Conditional Formatting to highlight overlapping dates on Vacation roster
    By JeremyJ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2022, 04:33 PM
  3. [SOLVED] Aggregating time overlapping events
    By kanderson9713 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-27-2021, 03:02 AM
  4. Identify overlapping events by time/date
    By Excel_NoneTheWiser in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-10-2021, 03:55 PM
  5. overlapping calendar events on a spreadsheet
    By ccpanel in forum Excel General
    Replies: 1
    Last Post: 02-04-2016, 09:15 PM
  6. charting overlapping events over time
    By joell in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-29-2010, 12:58 PM
  7. Highlight past & future events
    By rediproof in forum Excel General
    Replies: 4
    Last Post: 05-26-2005, 11:01 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