+ Reply to Thread
Results 1 to 3 of 3

Highlight hh:mm:ss when a threshold is exceeded

  1. #1
    Registered User
    Join Date
    09-25-2020
    Location
    North Carolina
    MS-Off Ver
    Window 10
    Posts
    2

    Highlight hh:mm:ss when a threshold is exceeded

    I want to have times highlighted when a certain threshold is reached.
    I am unable to accomplish this. Any assistance would be greatly appreciated.
    In the attached example if 00:15:00 minutes are exceed.

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

    Re: Highlight hh:mm:ss when a threshold is exceeded

    =(B2-TIMEVALUE("12:15:00 am"))>0
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    09-25-2020
    Location
    North Carolina
    MS-Off Ver
    Window 10
    Posts
    2

    Thumbs up Re: Highlight hh:mm:ss when a threshold is exceeded

    Thank you very much for responding and providing me with the answer. I am bald and I was pulling my hair out... 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. Highlight cells if staff has exceeded leave entitlement
    By dineshiam in forum Excel General
    Replies: 3
    Last Post: 08-11-2020, 01:41 AM
  2. Replies: 1
    Last Post: 11-30-2016, 08:02 PM
  3. [SOLVED] Count number of days a threshold is exceeded
    By Richiemouse in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-20-2014, 02:23 PM
  4. Counting periods where threshold is exceeded.
    By aartapple in forum Excel General
    Replies: 3
    Last Post: 03-26-2014, 03:06 AM
  5. Help on Sum of Working Hours + Alerts if exceeded threshold
    By rodcarv in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2013, 06:24 PM
  6. Replies: 6
    Last Post: 01-17-2011, 10:34 AM
  7. Count periods where threshold is exceeded
    By dieter99 in forum Excel General
    Replies: 7
    Last Post: 04-01-2009, 08:01 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