+ Reply to Thread
Results 1 to 2 of 2

Bulk add of Conditional formatting

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-31-2008
    Location
    Brazil
    MS-Off Ver
    Office 365
    Posts
    114

    Question Bulk add of Conditional formatting

    Hi,

    I have this table: http://imgur.com/jjNzxBZ

    I want to create a conditional formatting that will show conflicts in the schedules.

    For example, each text color refers to a train. So black is one train, blue is another, orange another. Look at the cells marked in yellow. Train black will arrive at the station at 14:00 and only depart at 15:00. But train blue is schedule to arrive at 14:40 and leave at 14:50. This is a problem, because it will crash.

    So when arrival time is lower than previous departure time it should mark to know there is a conflict.

    But I cannot only compare to the previous one, but all previous one.
    In the same example, train orange arrive at 15:00 it wont conflict with the previous train blue, that leave at 14:50, but it conflicts with train black. So it should compare to all previous ones.

    How do I add conditional formatting using a formula, but bulky. If I have to add one by one it will take ages, its 500 lines.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,943

    Re: Bulk add of Conditional formatting

    Post workbooks directly to the forum:
    To attach a Workbook
    (please do not post pictures or links to worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Ben Van Johnson

+ 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. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  2. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  3. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  4. Conditional Formatting in Bulk & Multiple IF Statements Within
    By liam_bettinson in forum Excel General
    Replies: 2
    Last Post: 09-01-2011, 09:45 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