+ Reply to Thread
Results 1 to 3 of 3

Highlight time in green based on real time?

  1. #1
    Registered User
    Join Date
    03-01-2016
    Location
    Phoenix, AZ
    MS-Off Ver
    MS Office 2013
    Posts
    94

    Highlight time in green based on real time?

    Hey guys,

    So I am laying out a task list with the Time in column A (see attached) and the Task in column B. I am wanting it to color the time cell in green based on the real time. Can this be done? Feel free to reformat how I have the time laid out if needed. I just want it to color the time cell in green - so if it is 7:45 it would highlight the 7:30-8:00 box.

    This is probably a bit of an odd request, but I would like to see if it can be done.
    Attached Files Attached Files
    Last edited by CC268; 09-13-2016 at 02:19 PM.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Highlight time in green based on real time?

    If you create few helper columns this is pretty doable.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-01-2016
    Location
    Phoenix, AZ
    MS-Off Ver
    MS Office 2013
    Posts
    94

    Re: Highlight time in green based on real time?

    Hmm not exactly what I was looking for...that is returning the current time...I just want it to highlight the block of time. If it is 7:45 then I want it to highlight the 7:30-8:00 block in green.

+ 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] Can't Stop Live Time / Real Time Clock
    By puuts in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-03-2014, 12:39 PM
  2. [SOLVED] How to create a real time report with on/off time and duration?
    By Why123 in forum Excel General
    Replies: 7
    Last Post: 11-21-2013, 02:01 AM
  3. Replies: 17
    Last Post: 11-15-2012, 06:12 PM
  4. Formula for Calculating Paid Time Off for fiscal anniversary date real time
    By 168rockwood in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-07-2012, 04:15 PM
  5. Replies: 4
    Last Post: 01-11-2012, 07:59 PM
  6. Documenting Static Real Time [Absolute Time] in a Cell
    By SDruley in forum Excel General
    Replies: 9
    Last Post: 06-23-2011, 10:30 PM
  7. Real time score based on currrent rank
    By Jlucas2 in forum Excel General
    Replies: 8
    Last Post: 08-12-2008, 02:54 PM
  8. [SOLVED] DDE real time and time dispay conflict
    By Ed Leshik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2005, 10:06 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