| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
apply conditional format to time
I have a spreadsheet (Excel 2003) that imports time data from another
application in the following formats displayed on the formula bar; for under one hour, it displays mm:ss When the time is over one hour, it displays h:mm:ss AM (or PM). When I apply conditional formatting, I can not get any time over one hour to color code. I have been unsuccessful changing the format of the imported data. Does anyone have a suggestion? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional date/time format | Excel Discussion (Misc queries) | |||
| Military Time Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional Format for negative time | Excel Discussion (Misc queries) | |||
| How do I apply conditional formatting? | Excel Worksheet Functions | |||
| ... I would like to apply more than 3 conditional formats ... | Excel Worksheet Functions | |||
![TD[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
