Results 1 to 10 of 10

Overlapping schedule conditional formatting issue

Threaded View

  1. #1
    Registered User
    Join Date
    06-28-2024
    Location
    Germany
    MS-Off Ver
    2021
    Posts
    21

    Post Overlapping schedule conditional formatting issue

    Hi people,

    I am making a schedule for 8 measurement stations (file is attached for convenience). What I'm trying to do is to make sure that the time from each measurement station does not overlap. In order for that to work, I need the conditional formatting function. The applied range for conditional formatting would be the same as every other rule, I presume (=$Y$3:$BDH$12).

    The interesting columns are from E to X, which contains start time/date and end time/date (Gamry). If any of the 10 Gamry start time overlaps with eachother, I want those cells highlighted with red. I am not sure what else I can explain. Once you see the file, I am sure you will understand.

    Thank you! Best regards
    FNasync_tool_final_draft_FNa.xlsx
    Last edited by fazalnajeeb; 07-10-2024 at 05:56 AM. Reason: solved

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 to Indicate On Schedule or Behind Schedule based on Times
    By Longbow 44 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-14-2023, 06:51 PM
  2. Overlapping conditional formatting
    By Sacruzsa in forum Excel General
    Replies: 1
    Last Post: 12-13-2022, 08:58 AM
  3. [SOLVED] Conditional Formatting with overlapping ranges
    By electricninja in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2017, 07:52 PM
  4. [SOLVED] Conditional Formatting - Overlapping Time
    By StartRunMSPaint in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-30-2014, 10:24 AM
  5. Overlapping bars with conditional formatting
    By MI_Analyst in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-23-2012, 04:52 AM
  6. overlapping conditional formatting
    By Xtopher in forum Excel General
    Replies: 8
    Last Post: 09-21-2011, 12:47 AM
  7. [SOLVED] vba overlapping conditional formatting
    By Susan J-P in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-11-2006, 01:10 AM

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