Forum Discussion
M.Yasir Fakhr
Feb 21, 2018Copper Contributor
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 |
- ShainaChoateCopper 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:59For 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:07Two 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
- ShainaChoateCopper ContributorI 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. - M.Yasir FakhrCopper Contributor
Thank you
Mr. Sergei Baklan