Conditional formating using H:MM

[cndn_hippo]

Hi there!

I'm working on a spreadsheet (using excel 2007) and I want to apply a conditional formatting rule that will change the cell colour if the H:MM is greater than 5:59.
Because I'm going to be dumping info into the spreadsheet every day from another spreadsheet so I don't want to have to tinker with the data before/after I've dumped the data. I've tried Conditional Formatting > Highlight Cell Rules > Greater Than... > Custom Format but that doesn't seem to work. It applies a false If True to all of the cells. Help please?

TIA!

 

[Scott Huish]

Cell Value is Greater than or equal to .25

 

[cndn_hippo]

Still getting false If Trues

 

[Scott Huish]

For what values?

This is the result of my conditional formatting:

<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ff0000; text-align:right; ">6:00 AM</td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">5:33 AM</td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="background-color:#ff0000; text-align:right; ">7:14 PM</td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td > </td><td > </td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span>