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?
--
David Biddulph

"TD" <TD @discussions.microsoft.com wrote in message
...
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?