Forum Discussion
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 |
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
- 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. Thank you
Mr. Sergei Baklan
