You've said "I am not getting this right with Conditional Formatting", but
you haven't told us what conditions you have tried to set in CF, nor what
your problem is. What value is in the cell, what result did you get, and
what result did you expect?

CF/ Cell Value Is/ less than 1 should do the job.
You will realise, I hope, that with a cell formatted as hh:mm:ss it will
always be *displayed* as less than 24:00:00. If you want to see values
beyond 24:00:00 you need to format as [hh]:mm:ss, but the format for the
hours display doesn't affect the value in the cell, and hence doesn't affect
the result from CF.
--
David Biddulph

"WildWill" wrote in message
...
Hi

I have a cell with data, formatted in hh:mm:ss. If the value in that cell
is
less than 24:00:00, then I want it to appear with a green format (i.e. the
cell is filled with green colour and the text remains black), if the value
is
greater than 24:00:00. then I want a similar effect but with the cell
filled
in red colour. I am not getting this right with Conditional Formatting.
Please help.