Forum Discussion

M.Yasir Fakhr's avatar
M.Yasir Fakhr
Copper Contributor
Feb 21, 2018

use conditional formatting with time

how to use conditional formatting with time,

If cell B is greater than 09:02:00 AM it should be highlighted in yellow, 

 

waiting best response

 

Date Time Remarks
1-Feb-18  8:50 AM C/In
1-Feb-18  5:59 PM C/In
2-Feb-18  9:21 AM C/In
2-Feb-18  6:02 PM C/Out
3-Feb-18  8:58 AM C/In
3-Feb-18  5:50 PM C/Out
6-Feb-18  9:18 AM C/In
6-Feb-18  6:06 PM C/Out
7-Feb-18 12:56 PM C/In
7-Feb-18  6:05 PM C/Out
8-Feb-18  9:22 AM C/In
8-Feb-18  6:03 PM C/Out
10-Feb-18  9:28 AM C/In
10-Feb-18  6:03 PM C/Out
13-Feb-18  9:20 AM C/In
13-Feb-18  6:02 PM C/Out
14-Feb-18  1:20 PM C/In
14-Feb-18  6:10 PM C/Out
15-Feb-18  9:11 AM C/In
15-Feb-18  6:01 PM C/Out
16-Feb-18  8:48 AM C/In
16-Feb-18  5:59 PM C/Out
  • ShainaChoate's avatar
    ShainaChoate
    Copper Contributor

    M.Yasir Fakhr 

     

    I have a problem regarding to Using Conditional Formatting Times in Excel.

    I need a range of times formatted as hh:mm:ss to be red if the time is ABOVE 00:01:00 and green if the time is BELOW 00
    :00:59

    For example I have:
    00:00:24
    00:00:37
    00:00:17
    00:01:27
    00:00:28
    00:00:18
    00:01:11
    00:00:07

    Two of these I want to turn red 00:01:11 and 00:01:27 but the rest should turn green.

  • Actually the time is number. You may apply the rule like

    =$B2>TIME(9,2,0)

    to highlight the cells

     

    • ShainaChoate's avatar
      ShainaChoate
      Copper Contributor
      I have a problem regarding to Using Conditional Formatting Times in Excel.

      I need a range of times formatted as hh:mm:ss to be red if the time is ABOVE 00:01:00 and green if the time is BELOW 00
      :00:59

      For example I have:
      00:00:24
      00:00:37
      00:00:17
      00:01:27
      00:00:28
      00:00:18
      00:01:11
      00:00:07

      Two of these I want to turn red 00:01:11 and 00:01:27 but the rest should turn green.

Resources