+ Reply to Thread
Results 1 to 2 of 2

Highlight with red font for the values more than 04:00

  1. #1
    Registered User
    Join Date
    03-17-2014
    Location
    hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    1

    Highlight with red font for the values more than 04:00

    Hi,

    I calculate the difference between two times and i got the result using the below formula.

    Example:-
    A2= 17/03/2014 10:00:00 AM , B2 = 17/03/2014 5:00:00 PM , Result :- 7:00

    Formula is " =TEXT(A2-B2,"[H]:MM") "


    If I want to Highlight with red font for the values more than 04:00 how to select the same from Excel Sheet by using conditional format or any other option.

    Please help.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Highlight with red font for the values more than 04:00

    Welcome to the forum.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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: 14
    Last Post: 05-25-2021, 02:13 AM
  2. [SOLVED] Formula to highlight cell (or change font color) when condition is met
    By Maezee in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2013, 04:17 PM
  3. Replies: 0
    Last Post: 10-12-2012, 01:08 PM
  4. Replies: 2
    Last Post: 10-01-2012, 10:00 PM
  5. Replies: 1
    Last Post: 05-08-2006, 02:05 PM

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