Results 1 to 2 of 2

Highlight column based on current hour

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-25-2012
    Location
    U.K
    MS-Off Ver
    Excel 2016
    Posts
    101

    Highlight column based on current hour

    Hi,

    In need of some help with a formula.

    I have a cell that contains a start date and a row that contains sequential date that begin with this start data.
    Underneath the dates i have a row that contains a sequential time for each date from 8:00 to 17:00.

    i also have a cell that contains the current time.

    What i am trying to do is highlight the column under the current date that has the current time.

    Please see below.

    Gantt Time.GIF
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 03-25-2022, 11:51 AM
  2. [SOLVED] Highlight column of current weeknumber
    By PatrickEasy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-30-2021, 05:14 AM
  3. Current cell row column highlight
    By rachelwahid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2019, 11:52 AM
  4. Highlight current row and column (ribbon) ????
    By Rmag in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2015, 10:43 AM
  5. Highlight current week column
    By podge in forum Excel General
    Replies: 2
    Last Post: 04-06-2010, 10:29 AM
  6. how do I highlight the current row and column
    By Ssalzman in forum Excel General
    Replies: 6
    Last Post: 05-14-2009, 07:10 PM
  7. highlight current row/column
    By RyanV in forum Excel General
    Replies: 1
    Last Post: 08-11-2006, 09:00 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