+ Reply to Thread
Results 1 to 6 of 6

Conditional Formatting based on time of day, regardless of date

  1. #1
    Registered User
    Join Date
    09-10-2019
    Location
    MD, USA
    MS-Off Ver
    Office 365
    Posts
    4

    Conditional Formatting based on time of day, regardless of date

    Hey All,

    I'm trying to figure out how to do some conditional formatting. I have a list of times in a collum that I use as a schedule for myself. I want to make it that any cell with a time past the current time of the current day will be highlighted a certain color. To be clear, the times are stored as just time, with no date.

    I know I can do this easily for just dates, but I can't seem to figure out how to do this with just time.

    Any ideas?

    Thanks!

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Conditional Formatting based on time of day, regardless of date

    =MOD(NOW(),1)>B275 as a condition
    in B275 time

  3. #3
    Registered User
    Join Date
    09-10-2019
    Location
    MD, USA
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Conditional Formatting based on time of day, regardless of date

    Could you explain that a little more?
    What do you mean "in B275 time"?

  4. #4
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Conditional Formatting based on time of day, regardless of date

    it that any cell with a time
    ______________________

  5. #5
    Registered User
    Join Date
    09-10-2019
    Location
    MD, USA
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Conditional Formatting based on time of day, regardless of date

    Is there something specific about the cell B275?

  6. #6
    Registered User
    Join Date
    09-10-2019
    Location
    MD, USA
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Conditional Formatting based on time of day, regardless of date

    Ok.
    I think I get it now.
    That last part is just whatever cell I'm putting the conditional formatting on.

    Thank you!

+ 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. Replies: 2
    Last Post: 07-19-2018, 04:04 AM
  2. [SOLVED] Conditional formatting based on date and time
    By Jalex5134 in forum Excel General
    Replies: 6
    Last Post: 10-26-2017, 05:55 PM
  3. Replies: 0
    Last Post: 06-15-2017, 06:28 PM
  4. [SOLVED] Conditional Formatting with Date/Time with Date/Time of another cell
    By jnepsa in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-20-2017, 10:48 AM
  5. [SOLVED] Conditional Formatting of Cells based off of date and time criteria
    By rhett7660 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-16-2015, 03:14 PM
  6. [Solved] Conditional Formatting based on date and time
    By HackerJL in forum Excel General
    Replies: 5
    Last Post: 06-08-2011, 06:58 PM
  7. Conditional formatting based on time
    By sharkey in forum Excel General
    Replies: 2
    Last Post: 12-24-2007, 02:13 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