Good afternoon all;
I am using Excel 2010, and have imported a report from Access database that includes a great deal of text and times, and I want to conditionally highlight values greater than 5 minutes. I have noticed that the description of the cells (provided by what I see when opening the imported workbook) says that they are text, but they display as shown below. I do not fully understand what that means, but it may be relevant.
Whenever I attempt to use the conditional formatting tool for "greater than" values it automatically highlights every cell in the list. When using the tool I enter values I am looking for as anything greater than 00:05:00. I have scoured the web for anything relevant with no success. I have also changed the format of the cells to number, time, text, and so on, but always achieve the same result.
The below list is the result of time intervals that were established in access. The times that these intervals were based on appear as (00-Jan-00) before formatting to display as times. The list looks like this (with the actual time to the left, and the interval on the right:
| 00-Jan-00 |
04:33:39 |
| 00-Jan-00 |
00:06:15 |
| 00-Jan-00 |
00:08:57 |
| 00-Jan-00 |
00:06:01 |
| 00-Jan-00 |
00:10:23 |
| 00-Jan-00 |
00:10:30 |
|
00:47:59 |
| 00-Jan-00 |
00:16:06 |
|
00:13:01 |
|
00:38:05 |
| 00-Jan-00 |
00:39:52 |
Thank you all for your help,
Robert