apply conditional format to time

[TD]

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?

 

[David Biddulph]

If a format change isn't having any effect, my guess is that your cell
contains text, not a number. Perhaps you've got spurious spaces or
non-printing characters?

 

[Peo Sjoblom]

It should work, I suspect your data is text, that's not unheard of when it
comes
to imports. Try if this work, custom format an empty cell [mm]:ss or
[hh]:mm:ss depending on what format you would like to have, then copy it,
select the imports and do edit>paste special and select add.

--


Regards,


Peo Sjoblom